My SQL is not performing well. Describe how will you fine
tune it?
- 1 Answers
- 5882 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 |
in a table consist of 1000 records among that i was updated 145 record how could i know that ..list of recently updated record's and where could i see those updated record's....pls help me out....
What does an outer join do?
What is dbrm?
Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?
Define db2.
What is a db2 table?
can all users have the privilage to use the sql statement select * (dml)?
How can you count the number of rows from a table tab?
What is database manager in db2?
What r the comman abends in db2, jcl and cobol???????
What is runstats db2?
i want to maintain uniqueness on pdf without make lf??????????
COBOL 
