RE: Anyway to optimize the optimizer

Ciao Jaromir

>A simple example is a table of events that have an opening and closing =
date.
>
>Does it mean, if I decide to partition on opening date and some one =
wont to
>report on closing date, I commited a design flaw?

In my opinion the opening/closing date should be checked at dimension = level and not on the fact. i.e. the structures used to support end-user = queries should be designed exactly for that.

Chris

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