Interested to Buy Any Domain ? << Click Here >> for more details...
My SQL is not performing well. Describe how will you fine
tune it?
- 1 Answers
- 6647 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / akbar
Use EXPLAIN to list out the access paths of several
different codes you come up with and choose the path that
got executed within the least time.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What is the difference between db2 and oracle?
Which command is used to connect to a database in DB2 ? Give the Syntax.
What action db2 takes when a program aborts in the middle of a transaction?
can we view the access paths created by dbrm ? how ? thx
What is buffer pool in the db2 database?
Can you tell me how can you find out the # of rows updated after an update statement?
Explain db2.
What is the role of schema in the db2 database?
What is dclgen (declaration generator)?
What is ibm db2 connect?
What is netezza database?
How does db2 sample database connect?
Why do chiropractors use drop table?
What is copy pending and check pending in db2?
How to create backup table in db2?
