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
- 18410 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 do I add a column to an existing table in db2?
How to check table size in db2 sap?
What is the use of commit in db2?
Name the various locking levels available?
Can we delete records from view?
What is collection in db2 bind?
Explain the function of data manager.
What action db2 takes when a program aborts in the middle of a transaction?
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
Define check constraint.
Define sqlca.
Which component is used to execute the sql statements?
How would the varchar column remarks defined?
Is db2 a mainframe database?
How to run db2 command in windows?
