What happens to the PLAN if index used by it is dropped ?
Plan is marked as invalid. The next time the plan is accessed, it is rebound.
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 happens if an invalid index value is passed to a function? 29.10.08
If an invalid index is passed, the function terminates without further processing. [Explanation] Functions that use an index value always determine if the index...What is the difference between index and subscript ? 31.07.08
Subscript refers to the array occurrence while index is the displacement (in no of bytes) from the beginning of the array. An index can only be modified using...What does the REORG Utility do ? 05.04.08
The REORG Utility will sort the index space and table space to conform with the primary index or clustering index specified in the DDL. It will also reclaim the...What is a composite index and how does it differ from a multiple index ? 01.04.08
A multiple index is not one index but two indexes for two different columns of a table. A composite index is one index made up of combined values from two col...What is an alias and how does it differ from a synonym ? 28.03.08
An alias is an alternative to a synonym, designed for a distributed environment to avoid having to use the location qualifier of a table or view. The alias is...What is the difference between TYPE 1 index & TYPE 2 index ? 26.03.08
TYPE 1 & TYPE 2 are specified when an index is created on the table. TYPE 2 index is the option which comes with DB2V4. With TYPE 2 index data can be retrie...What is the difference between SYNONYM and ALIAS ? 20.03.08
SYNONYMÂ Â Â : is dropped when the table or tablespace is dropped. Synonym is available only to the creator. ALIASÂ Â Â Â Â Â : is retained even if table...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....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 index ? 16.03.06
INDEX is a general term for an ORACLE / SQL feature used primarily to speed execution an impose UNIQUENESSÂ upon certain data. INDEX provides a faster access m...