What is an access path?

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


Please Help Members By Posting Answers For Below Questions

Explain what are the various isolation levels possible?

610


Explain the benefits you can get from mainframe connect?

522


What's The Percentage Free Space ?

775


Name the various locking levels available?

638


What is ibm db2 client?

523






What is a bind card?

681


What does sqlcabc has?

633


What does reorg do in db2?

578


What is sqlca?

625


What is iseries database?

597


Define sqlca.

651


What is db2 and what is the use of db2 optimizer?

656


What is netezza database?

574


How to compare data between two tables in db2?

660


How to take backup of table in db2?

601