The Plan_table is created under the AUTHID.

What do you need to do before you do EXPLAIN ?

Question Posted / naveen87ginjupalli

Answer Posted / naveen87ginjupalli

Is This Answer Correct ?

5 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What does db2 plan contain?

1022

How to test SQL -911 error while developing COB-DB2 program

7575

How will you return the number of records in table?

937

What is reorg?

1162

What is copy pending and check pending in db2?

1004

What is coalesce in db2?

1136

What is scrollable cursor in db2?

1055

How to compare data between two tables in db2?

1088

How to create backup table in db2?

1093

What is the meaning concurrency in the db2 database?

1110

What is the use of predicate?

1043

How do I import a csv file into db2?

991

Explain what are the various isolation levels possible?

1044

How do I delete a table in database?

1022

Why do chiropractors use drop table?

1109