MySQL Forums
Forum List  »  Optimizer & Parser

Re: Large range query stops using indexes
Posted by: Solomon Chang
Date: June 20, 2007 11:06AM

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.

Options: ReplyQuote

Written By
Re: Large range query stops using indexes
June 20, 2007 11:06AM
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.