How accurate is ALL_INDEXES.NUM_ROWS for the PK index?
- From: Thomas Kellerer <thomas.kellerer@xxxxxxxxxx>
- To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 16 Jan 2015 09:41:08 +0100
Hello list,
as a means to get a quick overview on how many rows each table has, I wonder
how accurate the NUM_ROWS column in ALL_INDEXES actually is for the primary key
index (or a UNIQUE index on a NOT NULL column).
Unlike other columns in that view (and e.g. the NUM_ROWS column in ALL_TABLES)
it is not marked as being dependent on gathering statistics.
So: when does Oracle update that information and how accurate is it?
Does it reflect the number of rows in "near real-time" (within the rules of
transactional visibility of course), or is it just as "unreliable" as
ALL_TABLES.NUM_ROWS?
Regards
Thomas
--
//www.freelists.org/webpage/oracle-l
Other related posts:
