Re: SQL question regarding overlapping date ranges
From: Jimmy Venema <jimmy.venema_at_philips.com>
Date: Fri, 11 May 2001 08:15:47 +0200
Message-ID: <9dg02q$9gr$1_at_porthos.nl.uu.net>
Date: Fri, 11 May 2001 08:15:47 +0200
Message-ID: <9dg02q$9gr$1_at_porthos.nl.uu.net>
It is not totally clear what you are trying to adchief, but when ranges are involved with operations on it, the normal index is often not sufficient, resulting in slow performance, since a full scan is required. Instead of a normally binary tree another tree structure e.g. R-tree must be used and not every (relational) database product supports such a tree structure.
Jimmy Venema Received on Fri May 11 2001 - 08:15:47 CEST