Re: Finding total Rows without count() ?

<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 - 09:28:13 CST