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 |
Explain correlated sub-queries.
if i made sme changes in sub pgm wht r the things to be done for this ?
What is database alias db2?
What is the SQL query to select, delete and get count of duplicate rows in DB2?
What is the max length of sqlca?
in my table i will update only 100 record among 1000 records i need to display recently updated record'.....can u tell me where those records are stored how can i display those records...?if there is any sql query pls let me know....?
How to resolve -407 sql code in DB2?
wht happens if we close cursor with cursor with hold option?
Define predicate?
What is rebind in db2?
what are the max. & min. no. of partitions allowed in a partition tablespace?
What happens to a cursor after a commit?