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

Written By
April 08, 2007 09:31AM
Re: Index on difference of two columns
April 11, 2007 06:38AM
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.