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

When will you chose to run RUNSTATS?

1 Answers  


Where do you specify them?

0 Answers  


Mention and explain the contention situations caused by locks?

1 Answers  


what are bind concepts in db2 cobol?

0 Answers  


What is the use of runstats in db2?

0 Answers  


Can one database have multiple instances?

0 Answers  


What is Call attach facility? How does it work?

1 Answers   Syntel,


What do you mean by storage group (stogroup)?

0 Answers  


What is an alias?

3 Answers  


What techniques are used to retrieve data from more than one table in a single SQL statement?

2 Answers  


DB2 is a A) data base/data communication system B) data base C) RDBMS D) Programming language

4 Answers   Accenture,


What is coalesce in db2?

0 Answers  


Categories