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

What is a PLAN table? How will you use it? Give the various fields of PLAN table?

What is the SQL query to select, delete and get count of duplicate rows in DB2?

what are extents?

What is declare cursor?

How would the varchar column remarks defined?

Which one allows duplicate values Union or Union All ?

What is check constraint. Explain with example.

List down the types of triggers in the db2 database?

How do I add a column to an existing table in db2?

How will fetch last 5 rows from table in db2

What is null in db2?

explain about index with examples

For more DB2 Interview Questions Click Here