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

Is db2 a mainframe?

What is ibm db2 client?

What if , we failed to mentioed null indicator in sql select query , that may retrieve null value ?

How does one bind 2 versions of a CICS transaction with the same module name in two different CICS regions that share the same DB2 subsystem?

How does cobol compile db2 program?

Why might full image copies be faster to implement than an incremental image copy?

I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?

What is cloudant database?

i want to maintain uniqueness on pdf without make lf??????????

What is deadlock?

What is a db2 table?

How do I import data from excel to db2?

For more DB2 Interview Questions Click Here