Re: Large range query stops using indexes
How are index scans a "random read"? Traditionally, indexes are normally B-Trees, unless specified otherwise. (I'm pretty sure that my index in question is a B-Tree).
...of which, I envision the query should an index for range scans as follows: Locate low value, locate high value, parse all in-between branches and return all leaves. It seems not to be doing that. Sigh.
Subject
Views
Written By
Posted
8246
June 11, 2007 10:43PM
3723
June 12, 2007 09:51PM
Re: Large range query stops using indexes
3770
June 20, 2007 11:06AM
3711
June 21, 2007 03:20AM
3272
February 28, 2009 04:49AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.