Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Advice on Date Range Partitioned Table
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