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

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

瀏覽:656
日期:2026-04-22
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...看更多