how long does a query take to run?

Question

I want to time a query. How do I do that? I want to change the order of the WHERE operators to see what will produce the best results; is this the best way to do it? I'm using sql server and .net 4.

Thanks.

Answer 1

Depending on what you're doing, you might be able to simply use a Stopwatch class to do your timing:

var stopwatch = new Stopwatch();
stopwatch.Start();
// Execute your query here
stopwatch.Stop();
Console.WriteLine("Elapsed time for query: {0}", stopwatch.Elapsed);

Answer 2

Sql Server Profiler will give you the best measurement of query speed. It comes with the SQL Management Studio.