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
- 6751 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 db2?
how can we find nth max salary from A table
What is the physical storage length of timestamp data type?
how to delete perticular row from table for ex. how you will delete 3rd row from table please answer THANKS IN ADVANCE
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?
What is a lock?
What is phantom read in db2?
What does an outer join do?
ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE
Can any one tell me about Restart logic in DB2.
How to rename a table in DB2 ?
how to fetch first 100 rows in db2
COBOL 
