What do you need to do before you do EXPLAIN ?
Make sure that the PLAN_TABLE is created under the AUTHID.
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
Why do you want to work for us? 17.12.08
This is your opportunity to explain that the company is exactly the type of company that you would feel proud to say you work for. It's also your chance to show...What is event handling? 21.11.08
The actions that are performed by clicking, pressing keys, moving mouse, dragging and dropping etc are called as events. Event handling is the way to capture th...Could anyone explain the testing process end to end? I you get a new project what you do, first as a test manager? Explain later steps too… 31.10.08
as a Tst manager u have to go through whole STLC. 1. Test planning 2. Test development 3. Test execution 4. Result analysis 5. Bug reporting 6. Prepar...Can any body explain clearly how to explain any (sales) project in interview.actually feom where report developer work starts?pls reply as soon as possible? 18.09.08
if you are a Report developer 1,you have to specify the front end and back end tool used for creating the reports 2,Then you have to tell the purpose of the p...Explain the EXPLAIN statement ? 14.07.08
The explain statement provides information about the optimizer's choice of access path of the SQL....How do you do the EXPLAIN of a dynamic SQL statement ? 13.03.08
There are two methods to achieve this: 1. Use SPUFI or QMF to EXPLAIN the dynamic SQL statement 2. Include EXPLAIN command in the embedded dynamic SQL stateme...Where is the output of EXPLAIN stored ? 13.03.08
In USERID.PLAN_TABLE...What is EXPLAIN? 13.03.08
EXPLAIN is used to display the access path as determined by the optimizer for a SQL statement. It can be used in SPUFI (for single SQL statement) or in BIND s...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 a join and explain different types of joins. 06.08.06
Joins are used in queries to explain how different tables are related. Joins also let you select data from a table depending upon data from another table. Ty...