hello i've update my database from 8.1.7 release 3 to 9i
and now following statement don't use my optimizer hint in 9i (in 8i it works) upper_artikel_kurztext_idx is an function based index select /*+ index_asc(artikel upper_artikel_kurztext_idx */ * from artikel where upper(kurztext) LIKE '%WANN%' when i change the statement it works but i need above statement select /*+ index_asc(artikel upper_artikel_kurztext_idx */ * from artikel where upper(kurztext) LIKE 'WANN%' or select /*+ index_asc(artikel upper_artikel_kurztext_idx */ * from artikel where upper(kurztext) = 'WANN' the following parameters are set in init.ora QUERY_REWRITE_ENABLED=TRUE QUERY_REWRITE_INTEGRITY=TRUSTED OPTIMIZER_MODE = CHOOSE database is analyzed ! any ideas thanx joe |
- Re: optimizer function based indexes Josef Huber
- Re: optimizer function based indexes Oliver Artelt
- RE: optimizer function based indexes Larry Elkins