Re: Cache hit rate

From: <larionov_at_yahoo.com>
Date: Tue, 19 May 1998 14:15:15 GMT
Message-ID: <6js45t$c69$1@nnrp1.dejanews.com>

How about the range queries? Suppose there is an index on a table, but I use the range query (like select sum...) which scans about half of the table. Does oracle use multiblock_read_count in this case or it still thinks this is the query via index lookup?

Thank you!

"Pei L. Ku" <pku_at_gte.net> wrote:
>
> Oracle uses multiblock_read_count for full table scan only. If the rows
> you are updating are fetched via index lookup, multiblock_read_count does
> not come into play.
>
> Pei
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Tue May 19 1998 - 09:15:15 CDT