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
- 18590 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
What are concurrency issues?
Describe major components of db2?
What is collection in db2 bind?
Explain packages.
Can you tell me how can you find out the # of rows updated after an update statement?
What is dbrm? What it contains? When it will be created?
Which command is used to connect to a database in DB2 ? Give the Syntax.
How to resolve deadlock issue
What is load utility in db2?
Explain various types of locks in db2?
Explain the function of data manager.
Define data page.
How to check last update on table in db2?
What is the use of db2 optimizer?
What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?
