Where is the access path logic created by the DB2 Optimizer stored?

Where is the access path logic created by the DB2 Optimizer
stored?

Question Posted / guest

Where is the access path logic created by the DB2 Optimizer stored?..

It is stored as bound plans/packages in the DSNDB01
directory in SKCT02, SKPT01 tablespaces.

Is This Answer Correct ?

4 Yes

2 No

More DB2 Interview Questions

What parameters are used to control the free space in DB2?

What can the Locate option of the Repair Utility accomplish?

WHAT IS MEANT BY COMMIT COMMAND?

Define predicate?

Mention a credible reason why select* is never given preference in an sql program that has been embedded.

what is difference between random and sequence file access

Where can you declare a cursor in a cobol-db2 program?

What does DSNDB07 database do?

Which component is responsible for processing sql statements and selecting access paths?

What is the usage of open cursor command?

What are leaf pages?

what is consistency token

For more DB2 Interview Questions Click Here