MySQL Forums
Forum List  »  Optimizer & Parser

Re: Why isn't the index being used?
Posted by: Bob Field
Date: June 12, 2006 06:41PM

Even without the index, there's only one row to scan. How many rows are in the table? Also how many rows are you expecting to match the WHERE since I see a LIMIT clause? If session IDs are unique, and you are selecting a particular one, how can more than one row be returned?

Options: ReplyQuote


Subject
Views
Written By
Posted
3333
June 12, 2006 06:11PM
Re: Why isn't the index being used?
1888
June 12, 2006 06:41PM
2148
June 13, 2006 08:41AM
1927
June 13, 2006 09:11AM
1942
June 13, 2006 09:54AM
1949
June 13, 2006 04:03PM


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.