Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: SQL question regarding overlapping date ranges

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@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 - 01:15:47 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US