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

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

瀏覽:607
日期:2025-06-16
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...看更多