What do you need to do before you do EXPLAIN ?

Answer Posted / naveen87ginjupalli

The Plan_table is created under the AUTHID.

Is This Answer Correct ?    5 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why db2 is called db2?

587


If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2

1569


Mention the location where the output received from explain statement is stored.

626


How do you pull up a query which was previously saved in qmf?

666


What is declare cursor?

608






Explain about rct.

643


How can you quickly find out the # of rows updated after an update statement?

626


What is a db2 schema?

758


What are union and union all?

535


What is runstats db2?

576


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

781


What is ibm db2 used for?

596


Name the various locking levels available?

627


What is the role of data manager in the db2 database?

636


Comment whether dclgen is mandatorily used. If not, then what is the point of using it?

599