Interested to Buy Any Domain ? << Click Here >> for more details...
What is an EXPLAIN in DB2.
How and what is the steps followed in EXPLAIN command. Can
all the queries be used in EXPLAIN command to check the
performance.
- 3 Answers
- 18378 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / s.v.venkata sivaprasad
explain is the db2 tool which used to improve db2
performance and provides best access path to package
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How is the value function used?
How do I delete a table in database?
What is rebind in db2?
Which command is used to remove all rows from a table?
What is the advantage in De-normalizing tables in DB2?
How to find primary key of a table in db2?
What is deadlock in db2?
What is the difference between cursor and select statement?
Which component is used to execute the sql statements?
What is difference between alias and synonym in db2?
How to view db2 table structure?
What are packages in db2?
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
What is plan in cobol db2?
i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?
