MySQL Forums
Forum List  »  Optimizer & Parser

Re: Index on difference of two columns
Posted by: KimSeong Loh
Date: April 11, 2007 06:38AM

Try this and index the position column
WHERE tab1.position < tab2.position + 15

I assume you are doing a self join, and using this as the join condition, and do note that this is still almost like a Cartesion product, the result can have huge number of rows.

Options: ReplyQuote


Subject
Views
Written By
Posted
3522
April 08, 2007 09:31AM
Re: Index on difference of two columns
2062
April 11, 2007 06:38AM
2082
April 12, 2007 12:06AM


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.