Re: Help: How should i partition this table

joe bayer wrote:
> I am using oracle 92. I have a table which has two date column,
> begining_time, and ending_time.
>
> The query usually is
> where
> begining_time > :b1
> and ending_time < :b2
>
> If i partition by beging_time, performace will degrade if :b1 gets smaller,
> if I partition by ending_time, the performace will degrade if :b2 gets
> bigger. I tried
>
> partition by range (ending_time, starting_time), the performace seems to be
> worse.
>
> Your help is highly appreciated.

And if you provide inadequate information when asking a question your performance will degrade to zero.

Partitioning by year? by month? by day, by hour? by minute? by second? What is the normal separation between the two times?

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)