Difference between NUM_ROWS and COUNT(*)

From: Thomas Klinger <t.klinger_at_nospam.mobilkom.at>
Date: Thu, 16 Dec 1999 14:27:18 +0100
Message-ID: <83apbn$oog$1@fleetstreet.Austria.EU.net>

Hi there!

A small question:
what's the difference between NUM_ROWS ind USER_TABLES and COUNT(*) from the same table?
i.e. in USER_TABLES I have for the table X the value 32410 in NUM_ROWS. With a select count(*) from X; I get the value 38986. Does the second value depends on the High-Watermark? Or is there some other reason?

Thanks for the answer.

--
Best regards,

T h o m a s K l i n g e r
Systemspecialist
mobilkom Austria AG

                         Contact information:
                         Tel.: +43-1-33161-5161
                         Mobil: +43-664-3315161
                         Fax: +43-1-33197911-5161
                         E-Mail: t.klinger_at_mobilkom.at

MOTH (Message of the hour):
There are some days when it takes all you've got to keep up with the losers. Received on Thu Dec 16 1999 - 07:27:18 CST