Where is the output of EXPLAIN stored?

Question Posted / guest

2 Answers
6734 Views
I also Faced
E-Mail Answers

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

What is the default page size of buffer pools?

0 Answers

Where besides the DB2 catalog is database object information stored by DB2?

1 Answers

what is the sqlcode -501

5 Answers IBM, Polaris, Zeus,

db2 query I have one table with the following details. SNO SNAME DOJ ------ -------------------- ---------- 10 KRISH 2007-03-19 20 REDDY 2007-05-19 30 RRRRR 2007-05-19 40 BBBBB 2008-05-19 50 CCCCC 2009-05-19 60 JJJJJ 2009-05-19 70 JJJJJ 2004-05-19 i want the output in the following format:( no of students joined in each year(no nedd to consider about month and date) year count --------- ---------- 2004 1 2007 3 2008 1 2009 2

9 Answers TCS,

What is the use of COMMAREA ?Minimum how much data we can pass from it?

7 Answers Cap Gemini,

Can any one tell me about Restart logic in DB2.

2 Answers

SI Stud name Subject Marks Pass/Fail 1 Sham Maths 40 P 1 Sham Physics 50 P 1 Sham Bio 20 F 2 Ram Maths 40 P 2 Ram Physics 50 P 2 Ram Bio 60 P For the above data , write the SQL query for the student who passed in all the subjects . For eg : I want the data of only Ram coz he passed all subjects .

2 Answers Cognizant,

How do you run JCL in cobol program

1 Answers IBM, Syntel,

What is a thread?

3 Answers

What is meant by AUTO COMMIT?

3 Answers

What is meant by index cardinality?

2 Answers

What is a lock?

1 Answers

For more DB2 Interview Questions Click Here