Re: Row Count

If you are using cost based optimization, you could run the query through explain plan, then report on the "cost". This will not give you a row count, but it will return a relative cost of the query. You will need to set up the explain plan table and report on it.

HTH
   James

In article <34D41FEE.5AB8_at_erols.com>, Bill Bollhorst <bbollhorst_at_erols.com> wrote:

>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

-- 
lorenzen_at_visi.com             | Life is complex; it has
                              |   real and imaginary parts