What do you need to do before you do EXPLAIN ?



What do you need to do before you do EXPLAIN ?..

Answer / naveen87ginjupalli

The Plan_table is created under the AUTHID.

Is This Answer Correct ?    5 Yes 0 No

Post New Answer

More DB2 Interview Questions

wht is d/f between union and joins ?

2 Answers  


What is db2 bind process?

0 Answers  


Can a Db2 table data be retrived through JCL?

4 Answers  


What is a clustering index?

2 Answers  


Can we use select * statement in cobol program without giving field names ???

3 Answers   Zensar,






ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE

0 Answers  


How many Buffer pools are there in DB2 and what are they?

1 Answers   IBM,


how do we solve soc 7 and soc4 ?

3 Answers   Tech Mahindra,


how 2 resolve the -311 sqlcode

1 Answers  


Suppose there are many duplicate records in a Db2 table. What is the query to retrive only duplicate records?

4 Answers  


How can the firstname and the lastname from the emp table be concatenated to generate complete names?

0 Answers  


How we create a tables in DB2 ?Previously client has using 7 letters for user id,now he wants to increase the letters from 7 to 12 for user id.How we can do it?

6 Answers   Wipro,


Categories