Function based indexes and or expansion.
OR expansion hint to do FFS instead of FTS
I won't reinvent the wheel, this post covers the issue:
https://dioncho.wordpress.com/2009/07/31/function-based-index-and-or-expansion/
There are different options, based on database version, index type and edition.
Or expansion cannot use function based indexes in 11.2 and below.
Related notes:
11.2 Bug 17650872 : WRONG RESULTS RUNNING QUERY WITH OR-EXPANSION AND FUNCTION BASED INDEX
Or expansion not supported with function based indexes in 11.2 and below.
https://support.oracle.com/epmos/faces/DocumentDisplay?id=281483.1&displayIndex=8#REF
I won't reinvent the wheel, this post covers the issue:
https://dioncho.wordpress.com/2009/07/31/function-based-index-and-or-expansion/
There are different options, based on database version, index type and edition.
Related notes:
11.2 Bug 17650872 : WRONG RESULTS RUNNING QUERY WITH OR-EXPANSION AND FUNCTION BASED INDEX
Or expansion not supported with function based indexes in 11.2 and below.
https://support.oracle.com/epmos/faces/DocumentDisplay?id=281483.1&displayIndex=8#REF
Comments
Post a Comment