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