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

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

755


What is a buffer in memory?

601


What is the connection string to connect to the DB2 Database ?

616


Explain db2.

620


How to compare data between two tables in db2?

660






What is reorg?

619


Is db2 free?

684


What is the maximum No of rows per page?

628


What types of tables are there in the db2 database?

559


Explain packages.

666


What is null in db2?

575


Define db2 and its databases?

622


Which components manage deadlocks in db2?

615


Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.

2325


What is the difference between nvl and coalesce?

604