[dba-SQLServer] Execution statistics

I usually don't pay too much attention to execution time (especially when it 
is a small query) because there are so many factors that can affect it that 
are outside of the database.  Number of reads provides more of a reliable 
and measureable benchmark in terms of fine tuning queries.

>From: "Susan Harkins" <ssharkins at bellsouth.net>
>Reply-To: dba-sqlserver at databaseadvisors.com
>To: <dba-sqlserver at databaseadvisors.com>
>Subject: RE: [dba-SQLServer] Execution statistics
>Date: Thu, 11 Aug 2005 17:33:56 -0400
>
>
>With the second new index, I can now get the query execution time under
>10ms.
>
>=========Seems to me that it's as much hit and miss as anything else. :) I
>know there's a rhyme to everything that's going on under the hood -- right
>now, I'm just guessing.
>
>Susan H.
>
>_______________________________________________
>dba-SQLServer mailing list
>dba-SQLServer at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
>http://www.databaseadvisors.com
>