|Subject:||Advice on Date Range Partitioned Table|
|Posted by:||Dereck L. Dietz (dietz…@ameritech.net)|
|Date:||Tue, 28 Nov 2006|
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