Row Count

The project I am currently working on has a requirement to provide feedback to the user about the query that (s)he has sent. This feedback consists of the number of rows that satisfy the query and 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 CST