My SQL is not performing well. Describe how will you fine
tune it?
- 1 Answers
- 5691 Views
- Accenture, I also Faced
- E-Mail Answers
Answer / 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 |
What is a cursor in programming?
What should be specified along with a cursor in order to continue updating process after commit?
How to compare data between two tables in db2?
what is the role of the cursor in db2?
What is a db2 table?
What is the difference between oracle and db2?
what is the maximum number of tables that can be joined ?
the dd name for ksds is dest1 and what is the dd name for alternate index of ksds ? a.dest b.dest1 c.dest1a d.dd1
define clustering index.
how to resolve -811 error. give clear explination
What does it mean if the null indicator has -1, 0, -2?
Which component is used to execute the sql statements?
COBOL 
