Is it possible to use another function that gives the same functionality as SOUNDEX for an index?
I don't know of any other that mimics SOUNDEX unless you try to write your own (yikes!). But any function can be used in creating an index. For example: CREATE INDEX my_idx ON mytable(UPPER(column))
Also remember that function-based indexes require query_rewrite_enabled be set to true and query_rewrite_integrity be set to trusted.
QUERY_REWRITE_INTEGRITY = TRUSTED
QUERY_REWRITE_ENABLED = TRUE
COMPATIBLE = 22.214.171.124.0 (or higher)
Dig Deeper on Oracle and SQL
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.