What is an access path?
- 3 Answers
- 5800 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / abhishek kale
Access Path is the path chosen by the DB2 Optimizer to
retrieve the data from a table in the most efficient manner.
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / anuj tiwari
The order in which the database fields are organized for processing in the program.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / guest
Access path used to give u the best path to access the data
in the DB2 table...
| Is This Answer Correct ? | 0 Yes | 1 No |
Define buffer pool.
What is an intent lock?
What is query for your birthday date should be in hours,minute and seconds format?
What is the maximum length of sqlca?
I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?
Mention the downsides of page level lock.
when i am trying to update a table having 1000 rows. the program abends.how we will come to know the last successful updated row was. we are not using any commit operations
How do you insert a record with a nullable column?
WHAT IS NULL INDICATOR ? WERE IS THIS USED? AND IF IT IS USED IN FILES CONCEPT? HOW DO WE USE IT?
What are packages in db2?
How many databases can be created inside an instance in db2 ?
How can record locking be achieved in those DB2 versions which do not support it?
COBOL 
