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
- 8983 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 a db2 table?
How do I delete a table in db2?
What are the various data types available in db2?
What is the max length of sqlca?
I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.
Where do you specify them?
How can you classify the locks in db2?
How to compare data between two tables in db2?
What is the information associated with sysibm.syslinks table?
What is null indicator in db2?
How can we retrieve the total number of records in RPG & CLLE?
What is the use of with ur in db2?
Explain db2.
What is dbrm?
What is copy pending and check pending in db2?
