1.

Approach To Improve The Performance Of A Query If It Is Very Slow?

Answer»

Check for following 

  1. Wildcards (e.g. chccom001. *) are not used in select.
  2. REFERS to used wherever references available. 
  3. Index_en used wherever possible. 
  4. UNWANTED joins removed from the main selects) If reference does not exist, select is split into 2 selects) MULTIPLE INDEXES on same table not used in one select. 

Check for following 


Discussion

No Comment Found

Related InterviewSolutions