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.
