MySQL Forums
Forum List  »  Optimizer & Parser

Re: suggestion for optimizing with non-matching compound indexes
Posted by: Björn Steinbrink
Date: March 22, 2006 09:12PM

Regarding the slow subquery I mentioned, this [1] bug report seems to match the needs for 'index skip scan simulation'. If the subquery becomes fast, the solution from my previous post should work quite well without the need for a second table.

[1] http://bugs.mysql.com/bug.php?id=15198

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: suggestion for optimizing with non-matching compound indexes
2043
March 22, 2006 09:12PM


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.