Re: [SQL] 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

[SQL] optimize self-join query

I have a table that stores a very large starting number called epc_start_numeric and a quantity. I've apparently built the most 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 ne