>A recent thread talked about differences of some way to acces data in regards of performance : SCAN, FOR, DO WHILE, ORDERED OR NOT, RUSHMORE...
>I think this is a very interesting issue.
>Here's a simple question : What is the best way to measure time spent on a statement? Is it simply by using TIME() before and after it.
>
>Thanks.

With TIME() there's extra work to do. You have to convert the character string to a numeric value. I'd recommend using SECONDS(), unless you were doing the test around midnight. Then you'd have to account for the value being reset to zero.

George