Re: dimension table
- From: Greg Rahn <greg@xxxxxxxxxxxxxxxxxx>
- To: kp0773@xxxxxxxxx
- Date: Tue, 8 Dec 2009 17:38:00 -0800
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
