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

What are the contents of dclgen?

658


What is db2 optimizer?

771


Name the various locking levels available?

634


How is a typical db2 batch pgm executed?

642


Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference

749






What is phantom read in db2?

636


Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?

2688


run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...

3791


List out the data types available.

704


what is the sqlcode -501

11304


what is the responsibility of the construction superintendent

1663


What is the use of runstats in db2?

577


What is db2 plan table?

622


What is a page in db2?

610


What is package in db2 mainframe?

558