Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Finding total Rows without count() ?
Obviously , %rowcount would not return full count until after last fetch and before
close. The point was that this may still be faster than count(*) on a very large table.
fumi wrote:
> <mgoelz_at_efn.org> wrote in message news:3856BD5E.C452B255_at_efn.org...
> > I am not at work to try this but would opening an explicit cursor on the
> > entire table (or just a canidate key) and then selecting %rowcount into
> > a variable which you then display be faster? If it is you could write a
> > script that contains the cursor to which you pass the table name on
> > execution.
>
> No.
> You can not know how many rows the cursor will return before fetch out all of rows.
Received on Thu Dec 16 1999 - 15:17:14 CST