What do you need to do before you do EXPLAIN?



What do you need to do before you do EXPLAIN?..

Answer / s

Create the Plan_table to holds the results of the explain.

Is This Answer Correct ?    5 Yes 0 No

Post New Answer

More DB2 Interview Questions

what is utility for parm lib

0 Answers   IBM,


What is the difference between a package and a plan?

6 Answers   Infosys, L&T, Mphasis,


Hi Dude,this is Ram.could any one tell me aboue CURRENT OF clause in DB2. Thanks in advance.......

2 Answers  


Generally if I want to select the names starting with c I need to use c% But how could I code to select the data which contains % as a part of data.

5 Answers  


is it compulsory commitment control in journal?

0 Answers   TCS,






What is db2 isolation?

2 Answers  


Which component is used to execute the sql statements?

0 Answers  


What is the difference between CS and RR isolation levels?

1 Answers  


what are extents?

5 Answers  


What are the various isolation levels possible?

0 Answers  


How and when does the db2 enforces the unique key?

0 Answers  


What happens to a cursor after a commit?

3 Answers  


Categories