What else is there in the PLAN apart from the access path ?
PLAN has the executable code for the SQL statements in the host program
If you liked this question/asnwer, make sure you
Subscribe to KyaPoocha.com RSS feed!
BOOKMARK THIS : BlinkList | del.icio.us | Digg it | Furl | reddit | StumbleUpon | Yahoo MyWeb |
Related Interview Questions
What is a bind? 25.08.08
Binding is a process that creates the access path logic for the sql statements within a cobol program. after precompilation of a cobol program a dbrm(has all th...What is a path ? 10.08.08
A path is a file that allows you to access a file by alternate index - the path provides an association between the AIX and the base cluster....When one binds a PACKAGE ( of a plan ) what package information is stored and where it is stored ? 12.04.08
The access path information for the PACKAGE is stored as skeleton package tables in the SPT01 table....Where is the access path logic created by the DB2 Optimizer stored ? 12.04.08
The access path logic is stored as skeleton cursor tables in the SCT02 Directory table....What happens to the PLAN if index used by it is dropped ? 16.03.08
Plan is marked as invalid. The next time the plan is accessed, it is rebound....Explain what a plan is? 07.03.08
Plan is a DB2 object (produced during the bind process) that associates one or more database request modules with a plan name....What is an access path? 07.03.08
The path that is used to get to data specified in SQL statements....What is Rule-based approach to optimization? 03.11.06
Choosing an executing plan based on the access paths available and the ranks of these access paths....How would you go about generating an EXPLAIN plan? 06.08.06
Create a plan table with utlxplan.sql. Use the explain plan set statement_id = ‘tst1′ into plan_table for a SQL statement. Look at the explain plan with utl...What is URL path 11.03.06
The part of a URL passed by an HTTP request to invoke a servlet. A URL path consists of the context path +servlet path + path info, where Context path is the pa...