Sign Up Login


  1. Categories >> Software >> MainFrame >> IBM MainFrame >> DB2
  2. Suggest New Category

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?..

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

Explain about open switch business continuity software?

0 Answers  

is it compulsory commitment control in journal?

0 Answers   TCS,

query to just fetch first matching row and stop execution. once one matching row is found ..no more records should be checked.. if the first record is matching.. the query must stop

2 Answers   IBM,

What is cursor stability?

1 Answers  

What is the maximum number of columns in a db2 table?

0 Answers   IBM,

What is a clustered index?

1 Answers  

What is the difference between using bind () and rebind () methods of naming class?

0 Answers  

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

2 Answers   Cap Gemini,

Can a unique index have more than one null value? If not, what error code is given if an attempt is made to insert more than one null value?

3 Answers  

What is universal database?

0 Answers  

pls tell me abt the normalization five types....

2 Answers  

What is normalization and what are the five normal forms?

1 Answers  

For more DB2 Interview Questions Click Here
Categories