RE: Anyway to optimize the optimizer

Hi Waleed

>I'm trying to achieve partition pruning when accessing a table using a
>column other than the partition key.

To achieve correct partition pruning you should have a restriction on = the partition key. If the actual structure doesn't provide it in a = simply way, in my opinion, the partition key was wrongly chosen! In fact = tricky queries just makes CBO live much harder and it's very difficult = to achieve a stable setup.=20

Chris

PS: In my opinion it makes only sense to fight the real problems, not = the issues resulting from them!

--
http://www.freelists.org/webpage/oracle-l