Interested to Buy Any Domain ? << Click Here >> for more details...
Explain the EXPLAIN statement?
- 1 Answers
- 5057 Views
- I also Faced
- E-Mail Answers
Answer / s
EXPLAIN, determines the access path that will be used by
DB2 to execute that particular SQL statment. The results
are written to the PLAN table.
| Is This Answer Correct ? | 1 Yes | 1 No |
How is the SUBSTR keyword used in sql?
What is the cascade rule and how does it relate to deletions made with a subselect?
What is the difference between primary key & unique index ?
what's the equivalent Cobol Data type for Decimal(x,y) in DB2? what does the current SQLID register contain?
3 Answers Cap Gemini, Tech Mahindra,
Can we install 2 different versions of Db2 on same mainframe?
where will u check for sqlcode ?
How do you filter out the rows retrieved from a Db2 table ?
What is a db2 collection?
How can the firstname and the lastname from the emp table be concatenated to generate complete names?
What is the purpose of coding FETCH in a SQL SELECT query? Explain with an example in Detail?
When can an insert of a new primary key value threaten referential integrity?
Can we declare cursor in Procudere division or open the cursor in the Working storage section. Is there any particular rules in the usage of cursors lifecycle
COBOL 
