Alan Shein <alanshein_at_erols.com> wrote in message
news:7v9t9e$ont$1_at_autumn.news.rcn.net...
> >>
> I would like to take a Select query and change it have it return a measure
> of the amount of time the it took to execute rather than the result set.
>
> Does anyone have any suggestions of ways to do this?
> <<
>
> SET TIMING ON
>
> Then run your query. A time value will automatically display (I believe it
> is in miiliseconds). Be sure to run the same query _at least_ twice. The
> first time will always be longer because the query needs to be parsed.
Once
> it is parsed, it will run faster because it is executed in its parsed form
> from memory until you execute a different query (and this is
> case-sensitive). You should compare the initial values for each query to
> each other, and then compare the subsequent values for each query. I would
> repeat the entire process several times, as your "mileage" may vary
> depending on server conditions.
Also, depending on whether the table has previously been accessed, some data
will be loaded into buffers, which will be more quickly accessed next time.
Received on Thu Oct 28 1999 - 18:50:48 CDT
