Re: Finding total Rows without count() ?

From: Brian Peasland <peasland_at_edcmail.cr.usgs.gov>
Date: Wed, 15 Dec 1999 14:18:51 GMT
Message-ID: <3857A34B.E3E463DA@edcmail.cr.usgs.gov>

> 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

Which concept of relational database theory is violated by storing or calculating the number of rows in a table?

> make any sense. People need to get out of the old mode of thinking of a

It makes sense to know the number of rows a table has. If you look in DBA_TABLES, there is a column called NUM_ROWS that gets populated when you analyze the table. The Optimizer makes use of this fact. Many DBAs find this number to be useful to them for certain situations.

HTH,
Brian Received on Wed Dec 15 1999 - 08:18:51 CST