Index on Date Column
Hi There,
Please let us know the way to efficiently create and use the index on date columns, our reports are using date columns in Selection crieteria (Data selected on date range which is described below).
e.g. our where_clause includes following
1. Trunc(Effective_Date) between To_date(:p_f_date) and To_date(:p_t_date)
2. to_number(to_char(trunc(last_update_date),'DDMMYYYY')) between To_number(To_Char(:p_f_date,'DDMMYYYY')) and To_number(To_Char(:p_t_date,'DDMMYYYY'))
3. to_number(to_char(trunc(last_update_date),'YYYYMMDD')) between To_number(To_Char(:p_f_date,'YYYYMMDD')) and To_number(To_Char(:p_t_date,'YYYYMMDD'))
Please let us know the way to efficiently create and use the index on date columns, our reports are using date columns in Selection crieteria (Data selected on date range which is described below).
e.g. our where_clause includes following
1. Trunc(Effective_Date) between To_date(:p_f_date) and To_date(:p_t_date)
2. to_number(to_char(trunc(last_update_date),'DDMMYYYY')) between To_number(To_Char(:p_f_date,'DDMMYYYY')) and To_number(To_Char(:p_t_date,'DDMMYYYY'))
3. to_number(to_char(trunc(last_update_date),'YYYYMMDD')) between To_number(To_Char(:p_f_date,'YYYYMMDD')) and To_number(To_Char(:p_t_date,'YYYYMMDD'))
0