Re: Finding total Rows without count() ?

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

Of course it doesn't store that. Repeat after me - "Oracle is a relational database". It would absolutely violate the concept of a relational database if the number of rows in a table were stored anywhere. It wouldn't even make any sense. People need to get out of the old mode of thinking of a relational database as being the same as other types of databases. They were the ones that historically implemented databased management incorrectly.

Why is it that everyone wants Oracle to behave as if it is lame, deaf, dumb and blind? If someone learns how to use a relational database correctly they wouldn't even think about applying archaic concepts to a relational database. Received on Wed Dec 15 1999 - 07:14:17 CST