HELP !! Function based index

Hello all,

I have a table in which I have a date column called d_timestamp. I have a function based index on this column

create index ix_sdt2_ts_fbi on stg_session_detail_t2 (to_char(d_timestamp,'DD-MON-YYYY'));

I run the following query and get a full table scan why?

SELECT a.time_id, a.date_dt, b.timestamp   FROM cdm_time_dim a, stg_session_detail_t2 b  WHERE to_char(a.date_dt,'DD-MON-YYYY') = to_char(b.d_timestamp,'DD-MON-YYYY');

I'm getting a fulltable scan on the stg_session_detail_t2 table.

Thanks in advance
Dan

Dan White
programmer/analyst Received on Wed Mar 07 2001 - 17:17:57 CST