Interested to Buy Any Domain ? << Click Here >> for more details...
what is the steps followed in EXPLAIN Process or EXPLAIN
command. (Explain is for identifying the optimized access
path but how or what is the steps for doing the EXPLAIN)
- 4 Answers
- 9182 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / krishna
In bind parameter if you give like
EXPLAIN(YES)
This will store the acess path in SYSIBM.SYSPLAN table,
it will not do any optimization.
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What is rebind in db2?
what is diffrence b/w file-aid tool and file-aid utility???
Which is faster delete or truncate?
What is db2 purescale?
How to find schema of a table in db2?
What is database alias db2?
What happens in bind step in a db2 program?
Mention the way of highlighting as well as putting a cursor to use in a cobol program.
B37 abend during spufi?
What is db2 catalog database?
When reorg is used?
Which component is responsible for db2 startup and shutdown?
List out the three types of page locks that can be held.
Which isolation level provides maximum concurrency?
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
