Where is the output of EXPLAIN stored?

Question Posted / guest

2 Answers
6936 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

I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?

1 Answers HeadStrong,

Can I use LOCK TABLE on a view?

1 Answers

Can one database have multiple instances?

0 Answers

Hi Team, Please tell me, If i don't declare the cursor in the program and i have given open and fetch and close, then what error will get.

6 Answers IBM,

What is the difference between IN subselects and EXISTS subselect?

1 Answers HCL, PreVator, TCS,

What is a collection in db2?

0 Answers

is it possible to get -811 error when you use cursors. why?

2 Answers IBM,

What is Reorg Recovery? when will you run it?

2 Answers

What is the purpose of the DSNC transaction ?

1 Answers

For Null indicator we have 3 values 0,-1,-2. 0->Not nulll -1->Null -2->Value truncated If ther is any possibility to have any positive value other than 0 in Null indicator.If it is so then when we will get and what is the value?

1 Answers BNP Paribas,

Where would you find information about the type of database authority held by the user?

2 Answers

Which components manage deadlocks in db2?

0 Answers

For more DB2 Interview Questions Click Here