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 |
I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.
0 Answers ITC Infotech, Syntel,
The only place of VSAM KSDS in DB2 is?
What are the prerogatives?
What os does db2 run on?
What is a view? Why use it?
What is cursor in dbms?
What is the difference between primary key & unique index ?
What does reorg do in db2?
What is null indicator in cobol db2?
I have a table(product),It contain fields(productname,cost). I want to retrieve the product name ,which cost is second maximum in the table?
What are the abend codes occour in ur latest PROJECT in DB2
List out the data types available.