My SQL is not performing well. Describe how will you fine
tune it?
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 the process of precompiler?
Why PS file called Physical seqential file?How to sore data in sequential file and ESDS file? What is the use of DBRM,PLAN,package and Collection.
What is the purpose of the WHENEVER statement?
how to resolve -811
what is a trigger and types of triggers
what is the differences between spufi and qmf and which is better?
4 Answers Accenture, Cap Gemini,
What are some characteristics of columns that benefit from indexes?
Explain the contention situations caused by locks?
is there any restrictions for unions ?
What will the DB2 optimizer do?
How could one combine a set of incremental image copies into a single copy?
What is the use of db2 optimizer?