What is an access path?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

List some fields from sqlca?

607


Which are the db2 tools to protect integrity of the database?

684


What is db2 instance?

590


What r the comman abends in db2, jcl and cobol???????

1814


define clustering index.

614






How is a typical db2 batch pgm executed?

638


Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....

1889


Explain about rct in db2?

633


How to take backup of table in db2?

595


How do I start db2 in windows?

554


What is universal database?

612


Explain about rct.

644


How to restart a DB2 program?

1353


When the like statement is used?

629


What does db2 mean?

579