I have tabel T1 with column col1. I have created function index on col1 - substr(func1(col1),0,45). Func1 is declared deterministic. I have set parameters query_rewrite_enabled=TRUE and query_rewrite_integrity ='TRUSTED'. When I issue query select col1 from T1 where substr(func1(col1),0,45) like 'sdsad%' then Oracle uses function index. I have also created view V1 as select substr(func1(col1),0,45) col1 from T1. When I issue query select col1 from V1 where col1 like 'sdsad%' then Oracle doesn't use function index. Have You got any idea why ???
Thanks in advance