Re: dimension table

From: Greg Rahn <>
Date: Tue, 8 Dec 2009 17:38:00 -0800
Message-ID: <>

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 <> 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.
Greg Rahn
Received on Tue Dec 08 2009 - 19:38:00 CST

Original text of this message