LIKE operator

From: Ralf <r.geronimi_at_bigfoot.com>
Date: Mon, 26 Oct 1998 19:36:48 +0100
Message-ID: <712f1g$k49$1@platane.wanadoo.fr>

I have a very important question about LIKE operator in SQL with Oracle :

the documentation say that
"

Pattern Matching on Indexed Columns When LIKE is used to search an indexed column for a pattern, Oracle can use the index to improve the statement's performance if the leading character in the pattern is not "%" or "_". In this case, Oracle can scan the index by this leading character. If the first character in the pattern is "%" or "_", the index cannot improve the query's performance because Oracle cannot scan the index.
"

But my request is like that :
SELECT ... FROM ... WHERE ... x like Y
,where x is a contant, and Y an indexed column of a table in the FROM part. Will Oracle use its index to improve performances ?

---

Raphael Geronimi Received on Mon Oct 26 1998 - 12:36:48 CST