Ado.NET - How to find the given query is optimised one ornot?

GeekInterview.com > Interview Questions > Microsoft > Ado.NET

Go To First | Previous Question | Next Question

Ado.NET | Question 2 of 31

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

Total Answers and Comments: 4

Last Update: September 11, 2008

Sponsored Links

Best Rated Answer

—

Submitted by: sahu

Hi,

First Excute Sql Quries in Query Analzer,see How much time 2 take Excute , if Less then the ur desired Time, then it will Optimize query

Above answer was rated as good by the following members:
surendra_sahu786

January 03, 2006 02:48:35

ishita

RE: How to find the given query is optimised one or&nb...

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.

Is this answer useful? Yes | No

April 05, 2006 02:03:01

Vishal

RE: How to find the given query is optimised one or&nb...

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

Is this answer useful? Yes | No

March 29, 2007 11:42:55

sahu

Member Since: December 2005 Contribution: 323

RE: How to find the given query is optimised one or&nb...

Hi

First Excute Sql Quries in Query Analzer see How much time 2 take Excute if Less then the ur desired Time then it will Optimize query

Is this answer useful? Yes | No

1 0

Overall Rating: +1

September 11, 2008 16:14:59

Pendurti

Member Since: September 2008 Contribution: 10

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

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

Is this answer useful? Yes | No

Go To Top

User Name		Remember Me?
Password

Question Bank