MySQL Forums
Forum List  »  Optimizer & Parser

Advanced Search
New Topic

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

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
suggestion for optimizing with non-matching compound indexes
4910
Nathan Cheng
March 08, 2006 12:39PM
Re: suggestion for optimizing with non-matching compound indexes
2274
Harrison Fisk
March 16, 2006 11:40AM
Re: suggestion for optimizing with non-matching compound indexes
2173
Nathan Cheng
March 16, 2006 12:15PM
Re: suggestion for optimizing with non-matching compound indexes
2942
Björn Steinbrink
March 22, 2006 09:48AM
Re: suggestion for optimizing with non-matching compound indexes
2103
Björn Steinbrink
March 22, 2006 09:12PM
Re: suggestion for optimizing with non-matching compound indexes
2105
Björn Steinbrink
March 24, 2006 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.