Where is the output of EXPLAIN stored?

Question Posted / guest

Answers were Sorted based on User's Feedback

Where is the output of EXPLAIN stored?..

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

More DB2 Interview Questions

Explain about mirror activator disk mirroring?

What are foreign keys in db2?

In which column of which DB2 catalog would you find the length of the rows for all tables?

What are the Isolation levels possible ?

What is role in db2?

What is a synonym? How is it used?

What is check constraint in db2?

What is meant by the attachment facility?

How to create backup table in db2?

Is it Possible to declare or create a cursor for UPDATE of table? If yes tell me how? If no Tell me why?

What is the STOSPACE Utility used for?

What is the role of data manager in the db2 database?

For more DB2 Interview Questions Click Here