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 are the contents of dclgen?

0 Answers  


Explain the benefits you can get from mainframe connect?

0 Answers  


What are the contents of a DCLGEN?

4 Answers   MetLife,


wht is d/f between union and joins ?

2 Answers  


what's the error code for Unique Index Violation?

2 Answers  






How to rename a table in DB2 ?

0 Answers   MCN Solutions,


Why select is not preferred in embedded sql programs?

0 Answers  


In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?

0 Answers  


what is the name of the default db2 catalog database?

3 Answers   IBM,


What is a clustered index?

1 Answers  


What do you mean by cursor?

0 Answers  


What is the maximum length of sqlca?

0 Answers  


Categories