Re: Does SQL*Plus' SET AUTOT TRACE STAT show correct # of gets ?

Update the statistics and look at the dba_tables.blocks value. This is how many blocks exist to the high water mark. It is possible your table has empty blocks below the HWM due to past deletes. A full table scan would read these blocks on its way to the HWM while the rowid check would not have identified these blocks since they contain no rows.

Autotrace has also been known to produce incorrect statistics and incorrect plans. That is neither is what actually occurred. Tom Kyte has posted on this subject and may have some information at asktom.oracle.com. But in your case I do not think bad statistics or plan is likely.

HTH -- Mark D Powell -- Received on Fri Dec 02 2005 - 09:16:03 CST