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

What is the information associated with sysibm.syslinks table?

657


What do you mean by storage group (stogroup)?

577


Define data page.

626


What is consistency token in db2?

636


What are union and union all?

537






Is db2 a mainframe?

581


can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well

1799


What is null indicator in db2?

599


List out the data types available.

695


What is cobol db2?

566


What is the max length of sqlca?

759


What are the various data types available in db2?

628


What is the physical storage length of time data type?

668


What is ibm db2 database?

530


If I have a view which is a join of two or more tables, can this view be updateable?

688