Re: Multi-Column Partition keys

From: Dmitry Sirotkin <sdmitry1_at_mail.ru>
Date: Tue, 8 Feb 2000 18:13:14 +0300
Message-ID: <87pbkv$edo$1@news.rinet.ru>

Hi, Mike!

Mike Winterer wrote in message <389F8338.329483B6_at_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 )

Maybe you should try to rewrite your where-clause in the following way: WHERE NOT ( endtime < '10-JAN-2000' OR starttime > '11-JAN-2000')

And have you tried to get the plan of your queries like this? Is index on these columns really being used?

With best wishes,
Dmitry. Received on Tue Feb 08 2000 - 09:13:14 CST