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 |
What is the error code -803 ?
I am getting a error multiple row fetched while executing a Cobol-DB2 program.How can I solve it without using a cursor.
B37 abend during spufi?
how does the defining of a stored procedure effect the size of a DB2 data base A) it increases the size of a data base B) it decreases the size of a data base C) it does not effect the size of the data base D) it changes the table space structures
How do I change the column size in db2?
Plan has the optimized access path in it. But is that optimized access path is attained or known
What is the physical storage length of date data type?
What is a correlated sub query?
What is database manager in db2?
what is differnece between DROP TABLE & DELETE TABLE .
What are foreign keys in db2?
List out the three types of page locks that can be held.