Row Count

[Quoted] [Quoted] The project I am currently working on has a requirement to provide [Quoted] [Quoted] feedback to the user about the query that (s)he has sent. This [Quoted] [Quoted] feedback consists of the number of rows that satisfy the query and [Quoted] the amount of time to satisfy the query.

The customer's idea is that if the user sends a large query and they are informed about it ASAP, they can take action to abort the query or let it run in the background.

Personally I laughed when I saw these. :-) How do you get the number of rows and/or time without actually doing the query? If you are going to waste the time counting the rows, just do the query.

If there is an answer or a compromise to address this type of requirement I would appreciate an opinion.

Thanks in advance,

        Bill Received on Sun Feb 01 1998 - 00:00:00 CET