How do you Optimize query

How can i choose which query is best?
i.e On which factors i can choose the best query?

Questions by ramesh.akula9

Showing Answers 1 - 3 of 3 Answers

madanuprashanth

  • Jul 18th, 2008
 

By forcing the SQL engine to use indexes.
If query is too much nested then break it into two or three queries using temp tables and then write one query by joining these temp table to perform the task.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions