it no more shows a high cpu cost over dim_date . It is a date data type filed. On Tue, Dec 8, 2009 at 5:38 PM, Greg Rahn <greg@xxxxxxxxxxxxxxxxxx> wrote: > When you make the predicate change, how did the execution plan change? > That should help with knowing what plan you want. > > Is dim_date.CALENDAR_DATE a varchar or date data type? If it's date, > it should be cast as one using to_date. > > > On Tue, Dec 8, 2009 at 5:13 PM, Kar <kp0773@xxxxxxxxx> wrote: > > > > right now in the where clause of the query > > dim_Date.CALENDAR_DATE In ( '17-NOV-2008' ) > > there was a index on the calender_date in dim_date . but the index on > date > > column is not helping here. > > However when i changed it to dim_Date.date_key=100830 the query came > out > > in few sec. > > -- > Regards, > Greg Rahn > http://structureddata.org >