Re: Finding total Rows without count() ?

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.

Ken Sproule wrote:

> As always, thanks in advance for your help.
>
> I need a fast way to determine the total number of rows in a table. I
> assume somewhere Oracle stores such information about its tables.
> Where is it?
>
> The count() type syntaxes take much too long on tables of say 3+
> million rows, so I'm looking for a fast way to accomplish it.
>
> Post answers to the group, as others might be interested also.
>
> Thanks,
>
> Ken Sproule
> kenmn_at_tds.net
Received on Tue Dec 14 1999 - 15:57:50 CST