How to find the given query is optimised one or not?

Editorial / Best Answer

Answered by: Vishal

  • Apr 5th, 2006


You can use Execution Plan in SQL server to see the cost of your querry.By this you can optimised your query.

Showing Answers 1 - 0 of 0 Answers

ishita

  • Jan 3rd, 2006
 

Using the power of the SQL Profiler and running a simple trace to capture the performance of your stored procedures can easily obtain these query lists. that needs tuning.

  Was this answer useful?  Yes

Vishal

  • Apr 5th, 2006
 

You can use Execution Plan in SQL server to see the cost of your querry.By this you can optimised your query.

Pendurti

  • Sep 11th, 2008
 

There is something called Query analyzer that u can make use of to find out whether the given query is optimized or not. 


  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.

Answer Question

Click here to Login / Register your free account


 
Send   Reset

 

Related Answered Questions

 

Related Open Questions