How would you go about generating an EXPLAIN plan?
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 utlxplp.sql or utlxpls.sql
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
Explain complete process followed for the development of project? 05.11.08
first we must have to pre plan like analyse the cost, resources and time involved then if it is profitable we must have to take up. Then we must have to p...What is test Strategy ? whether it’s comes under test plan? Explain me? 31.10.08
est strategy--It is a company level document.it tells u how to approach testing process. Test plan -- It ia a project level document.it tells u how testing...DB2 What is the difference between a package and a plan? How does one bind 2 versions of a CICS transaction with the same module name in two different CICS regions that share the same DB2 subsystem? 03.04.08
Package and plan are usually used synonymously, as in this site. Both contain optimized code for SQL statements - a package for a single program, module or subr...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....What else is there in the PLAN apart from the access path ? 16.03.08
PLAN has the executable code for the SQL statements in the host program...Where are plans stored ? 10.03.08
Each plan is defined uniquely in the SYSIBM.SYSPLANS table to correspond to the transaction (s) that are to execute that plan....What will the FREE command do to a plan ? 09.03.08
It will drop(delete) that existing plan....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 execution plan? 04.07.06
The combinations of the steps the optimizer chooses to execute a statement is called an execution plan....What is Execution Plan ? 26.03.06
The combinations of the steps the optimizer chooses to execute a statement is called an execution plan....