Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Multi-Column Partition keys
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
![]() |
![]() |