> > Is it really much quicker than: > select min(rowid) from testtableint having rowid>2; > and is there a way to show the time a query takes to execute ?
I guess this what you mean: select min(rowid) from testtableint where rowid>2 because having can only be used together with "group by" I think it is not that fast because it has to do aggregate-functions, which mean an extra overhead, and extra above this fact, it is impossible to retrieve other fields when doing an aggregate, which means two queries have to be executed to get the compleet row. But now we are here, is there a way to retrieve the number of rows a table has without getting all the rows? thanks in advance Bert Verhees --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]