optimizer function based indexes

From: Josef Huber <oracle-db_at_bretterbauer.at>
Date: Tue, 02 Oct 2001 00:11:04 -0700
Message-ID: <F001.0039E5B2.20011002001518@fatcity.com>

hello i've update my database from 8.1.7 release 3 to 9iand now following statement don't use my optimizer hint in 9i (in 8i itworks)upper_artikel_kurztext_idx is an function based indexselect /*+ index_asc(artikel upper_artikel_kurztext_idx */ * from artikelwhere upper(kurztext) LIKE '%WANN%'when i change the statement it works but i need above statementselect /*+ index_asc(artikel upper_artikel_kurztext_idx */ * from artikelwhere upper(kurztext) LIKE 'WANN%' orselect /*+ index_asc(artikel upper_artikel_kurztext_idx */ * from artikelwhere upper(kurztext) = 'WANN'the following parameters are set in init.oraQUERY_REWRITE_ENABLED=TRUEQUERY_REWRITE_INTEGRITY=TRUSTEDOPTIMIZER_MODE = CHOOSEdatabase is analyzed !any ideasthanx joe Received on Tue Oct 02 2001 - 02:11:04 CDT