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

Home -> Community -> Usenet -> c.d.o.server -> Multi-Column Partition keys

Multi-Column Partition keys

From: Mike Winterer <mikew3_at_corp.earthlink.net>
Date: Tue, 08 Feb 2000 02:45:03 GMT
Message-ID: <389F8338.329483B6@corp.earthlink.net>


We have a situation where there are 2 date columns (starttime and endtime) in a table and our most
 common query is of the form

 select ..
 from ..
 where (starttime between '10-JAN-2000' and '11-JAN-2000')  or (endtime between '10-JAN-2000' and '11-JAN-2000')  or ('10-JAN-2000' between starttime and endtime )

 Note that the date range requested can be a day, week, or a month. Also note that the date cover
 the range of seconds between midnight and midnight. These are not TO_CHAR(:date) values.

 The question is "can we partition on both date columns?" If we partition on only one or the other
 dates then there will be some records outside of that single column range. With the query that we
 are using above we would eliminate some of the search but still have to scan the entire index to
 find the range of records of the non-partitioned column.

 If we can partition on both of the date columns how will that change our queries? Received on Mon Feb 07 2000 - 20:45:03 CST

Original text of this message

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