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

Where is the output of EXPLAIN stored?

List out the buffer pools in db2

What is an instance in db2?

Define db2 and its databases?

Shall i use this query to retrieve first 4 records, Select empno, sal from emptbl where empno < 5. like this can we fetch first 100 records?

where will u check for sqlcode ?

why db2 is called as universal database?what is the storage capacity of db2v9 n what are the advantages of db2

Request to database but database is not available so what is was abend is raised?

What is precompiler in db2?

Is it possible to update a primary key value? If not, what is the error code given? If yes, can more than 1 primary key column be updated at a time?

What is JOIN and different types of JOIN.

Is the primary key a clustered index?

For more DB2 Interview Questions Click Here