What is an access path?
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 |
How would you find out the total number of rows in a db2 table?
What is access path in db2?
Explain about dbrm.
what is the use of cursors?
What is the difference between oracle and db2?
How Plan is created while executing the query using SPUFI?
What is difference between *omit and *nopass?
Define db2 and its databases?
What is the difference between dbm cfg and db cfg file in db2 ?
What is ibm db2 connect?
i have an employment table whch has salary,dept,name? i want salary b/w 1000 to 5000 can anyone pls say the query for ths ?
8 Answers Cap Gemini, CGI, EDS, IBM, Satyam, Wipro,
Can we able to find all the Table names under a Particular Plan?