oracle - PL/SQL Performance Tuning for LIKE '%...%' Wildcard Queries - Stack Overflow

oracle - PL/SQL Performance Tuning for LIKE '%...%' Wildcard Queries - Stack Overflow

瀏覽:920
日期:2025-04-25
We're using Oracle 11g database. As you may or may not know, if you use wildcard query with "%" in front of the string, the column index is not being used and a full table scan is happening. It looks like there isn't a definitive suggestion on how to impr...看更多