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
- 6662 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
Explain about cursor stability?
How to fetch the last row from the table in SQL (db2)?
What is the use of commit in db2?
Mention data types used in db2 ?
What is the advantage in De-normalizing tables in DB2?
Explain the contents that are a part of dclgen.
What is reorg and runstats in db2?
How to find schema of a table in db2?
How would you find out the total number of rows in a db2 table?
How to find the number of rows in db2 tables?
What does db2 stand for?
Explain dclgen.
What is bind package and plan in db2?
What is the physical storage length of date data type?
What is drop table?
