My SQL is not performing well. Describe how will you fine
tune it?
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
What is cursor stability in db2?
Comment whether dclgen is mandatorily used. If not, then what is the point of using it?
What is a db2 package?
List some fields from sqlca?
How do I delete a table in db2?
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
Can you tell me how can you find out the # of rows updated after an update statement?
What is db2 catalog database?
Explain about cursor stability?
What are union and union all?
What is the function of logging in the db2 database?
What is db2 purescale?
How do I delete a table in database?
How can you find out the # of rows updated after an update statement?
What's The Percentage Free Space ?