Re: optimize self-join query

Thanks to everyone for all the thoughtful responses.  They have been incredibly helpful.

Ended up optimizing per Lee, and creating buckets per Tom.  Thanks again.

On Oct 25, 2011, at 2:37 PM, Ty Busby wrote:

I have a table that stores a very large starting number called epc_start_numeric and a quantity.  I've apparently built
themost inefficient query possible for doing the job I need: find out if any records overlap.  Imagine the
epc_start_numeric+ quantity representing a block of numbers.  I need to find out if any of these blocks overlap.