MySQL Forums
Forum List  »  Optimizer & Parser

Re: SELECT on multiple column index
Posted by: Andr Schršder
Date: December 10, 2004 10:23AM

I have tried doing using handlers before some time in the past.

Unfortunately it incurs loads of overhead because of the handler creation and the handler drop. As far as I can remember, you can't keep the handler open because it conflicts with other connections and insert/update, right?

Why does the above query not use the index? Why can't I force it to? It understands the query correctly and the results are consistent.

Options: ReplyQuote


Subject
Views
Written By
Posted
9577
December 05, 2004 07:18AM
3330
December 09, 2004 09:08AM
3428
December 09, 2004 11:23AM
3051
December 09, 2004 07:38PM
3255
December 10, 2004 07:51AM
4325
December 10, 2004 08:42AM
Re: SELECT on multiple column index
3004
December 10, 2004 10:23AM
3395
December 10, 2004 11:02AM


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.