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 |
wht is d/f between union and joins ?
What is db2 bind process?
Can a Db2 table data be retrived through JCL?
What is a clustering index?
Can we use select * statement in cobol program without giving field names ???
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
How many Buffer pools are there in DB2 and what are they?
how do we solve soc 7 and soc4 ?
how 2 resolve the -311 sqlcode
Suppose there are many duplicate records in a Db2 table. What is the query to retrive only duplicate records?
How can the firstname and the lastname from the emp table be concatenated to generate complete names?
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?