I have a query that looks like
from fact, dim_time
where fact.my_dt = dim_time.clndr_dt
and fact.my_dt between '1-jan-2005' and '10-mar-2005'
this query eliminates partitions which are based on week.
Now, if i replace the literal strings in the between clause with some kind of sub-queries that provide the values at run time, the partitions dont get eliminated. any ideas, clues, suggestions, advices? all are welcome and appreciated.
May 27, 2005 8:09 PM
June 6, 2005 1:38 PM