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 compare data between two tables in db2?

0 Answers  


Suppose I have a program which uses a dynamic SQL and it has been performing well till now. Off late, I find that the performance has deteriorated. What happened?

1 Answers  


Where is the output of EXPLAIN stored?

2 Answers  


What is copy pending and check pending in db2?

0 Answers  


When do you use the IMAGECOPY?

4 Answers  


Which component is responsible for processing sql statements and selecting access paths?

0 Answers  


What are the uses of db2 optimizer?

0 Answers  


What kind of database is db2?

0 Answers  


How do I create a table MANAGER (EMP-NO, MANAGER) where MANAGER is a foreign key which references to EMP-NO in the same table? Give the exact DDL.

3 Answers  


What is a base table?

2 Answers  


What is cobol db2?

0 Answers  


What is the difference between Primary key and unique index?

6 Answers  


Categories