Re: Help: How should i partition this table

From: joe bayer <joebayerii(no-spam)_at_hotmail.com>
Date: Thu, 26 May 2005 06:28:53 GMT
Message-ID: <F0ele.2845$Ri3.2057@trnddc09>

What do you mean ?

There is 52 weekes each year, so if we partition by week, there will be 520 weeks for 10 yrs. And the query
"select count(*) from A where end_time > to_date('2005/01/01','yyyy/mm/dd') "
will scan all 520 partitions, will it?

---Partition by week and no query will look at more than 2 weeks worth of data.

What do you mean by this?

> Partition by week and the problem disappears completely doesn't it?
> Right now your query hits 4.3 weeks worth of data possibly crossing
> to 8.6 weeks. Partition by week and no query will look at more than
> 2 weeks worth of data.
> --
> Daniel A. Morgan
> Relational theory is not something that is simply a nice-to-have.
> http://www.psoug.org
> damorgan_at_x.washington.edu
> (replace x with u to respond)
Received on Thu May 26 2005 - 01:28:53 CDT