My SQL is not performing well. Describe how will you fine
tune it?
- 1 Answers
- 5883 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
Define predicate?
How do we specify index to include or not during bind process.
Why db2 is called db2?
What is copy pending status in db2?
Define data page.
SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected
How can you classify the locks in db2?
What is null value in db2?
What is check constraint. Explain with example.
Explain about rct.
How to test SQL -911 error while developing COB-DB2 program
What is the latest version of ibm db2?
My sql statement select avg(salary) from emp yields inaccurate results. Why?
Can there be more than one cursor open for any program?
What is a trigger in the db2 database?
