Re: dimension table
- From: Kar <kp0773@xxxxxxxxx>
- To: Greg Rahn <greg@xxxxxxxxxxxxxxxxxx>
- Date: Tue, 8 Dec 2009 18:21:49 -0800
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
>
Other related posts:
