What do you need to do before you do EXPLAIN?

Answer Posted / s

Create the Plan_table to holds the results of the explain.

Is This Answer Correct ?    5 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is database reorganization?

589


what are bind concepts in db2 cobol?

649


What is the physical storage length of time data type?

673


What language is db2 written in?

595


What is the use of runstats in db2?

577






Which component is responsible for db2 startup and shutdown?

630


Is db2 a mainframe database?

567


How would the varchar column remarks defined?

635


What is image copy in db2?

570


What is db2 stogroup?

675


What are types of indexes?

593


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

632


What is cursor stability in db2?

811


What r the comman abends in db2, jcl and cobol???????

1818


Mention some fields that are a part of sqlca.

603