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 -> Advice on Date Range Partitioned Table

Advice on Date Range Partitioned Table

From: Dereck L. Dietz <dietzdl_at_ameritech.net>
Date: Tue, 28 Nov 2006 01:42:45 GMT
Message-ID: <puMah.15538$6t.3708@newssvr11.news.prodigy.com>


Environment: Oracle 10g R2

There is a large table where I work which is currently in 10 partitioned by a DATE field. The DATE field is also indexed.

The person who is responsible for the table has complained that the index which is on the partition key isn't being used. He is convinced the reason is that the partition key is a DATE field and that it should instead be a contrived field of just the year.

At a meeting today I was given the task of determining whether that was a sound idea or not and I'm not really sure where to start to either confirm it or not. I may be completely wrong but I can't see where using a contrived YEAR would be any different than a DATE.

Can anybody offer any advice and/or point me in the right direction of where to look?

Thanks. Received on Mon Nov 27 2006 - 19:42:45 CST

Original text of this message

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