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
- 9159 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 the sqlcode -501
What is access path in db2?
What db2 400?
What is collection in db2 bind?
can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well
what is diffrence b/w file-aid tool and file-aid utility???
Is it possible to create an Instance in DB2 using DB2 Control Center ?
How to find primary key of a table in db2?
What is coalesce in db2?
Why select is not preferred in embedded sql programs?
Discuss about db2 bind?
Which isolation level provides highest data integrity?
What is the clustering index in the db2 database?
What is package in db2 mainframe?
What is a bind card?
