Where is the output of EXPLAIN stored?

Answers were Sorted based on User's Feedback



Where is the output of EXPLAIN stored?..

Answer / s

The Explains writes the output to the PLAN TABLE

Is This Answer Correct ?    5 Yes 0 No

Where is the output of EXPLAIN stored?..

Answer / mainframe.rahulz

EXPLAIN stores output in PLAN_TABLE

Is This Answer Correct ?    5 Yes 0 No

Post New Answer

More DB2 Interview Questions

How to fetch the uncommited data from table ?

1 Answers   JPMorgan Chase,


How will you return the number of records in table?

0 Answers  


What is the use of reorg in db2?

0 Answers  


Could anyone clearly explain the diference between sub query and correlated sub query?

3 Answers  


what is cursor stability?

2 Answers   IBM,






What is a db2 table?

0 Answers  


What is the purpose of rollback and commit?

0 Answers  


What are the two types of logging in the db2 database? Explain them.

0 Answers  


What are the bind parameters ibm db2?

0 Answers  


What is the difference between group by and order by?

2 Answers   IBM, TCS,


Q4. How will you get the count of record without using COUNT verb in query?

2 Answers   IBM,


What r the comman abends in db2, jcl and cobol???????

0 Answers   Mphasis,


Categories