Last updated on DECEMBER 24, 2014
Applies to:Oracle Database - Standard Edition - Version 220.127.116.11 to 18.104.22.168 [Release 7.0 to 11.2]
Oracle Database - Enterprise Edition - Version 22.214.171.124 to 126.96.36.199 [Release 7.0 to 11.2]
Oracle Database - Personal Edition - Version 188.8.131.52 to 184.108.40.206 [Release 7.1.4 to 11.2]
Information in this document applies to any platform.
A query that contains a character "_" in its condition clause may get higher consistent gets for the LIKE operation as opposed to when the "=" operator is used, even though the wildcard "%" is not included in the query.
select * from test_like where a like '11_000028950';
--Query with =
select * from test_like where a = '11_000028950';
The plan for the query looks similar however when comparing the consistent gets we see higher consistent gets with LIKE.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms