Answer Posted / 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 |
Post New Answer View All Answers
What is runstats and reorg in db2?
What are the rules for db2 programming?
Where do you specify them?
What is schema in db2?
What is the difference between db2 and oracle?
What are the full forms of spufi and dclgen and why are they used?
What is the syntax for FETCH in DB2 ?
Explain db2.
What's The Error Code For Unique Index Voilation?
Why cursor is used in db2?
What is the meaning concurrency in the db2 database?
What is copy pending and check pending in db2?
Where can you declare a cursor in a cobol-db2 program?
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
How can you find out the # of rows updated after an update statement?
