General information
Title:
UPPER expression with LIKE comparison
we have a index with this expression - UPPER{"CLASTNAME")
our sql statement
Select * from MyTable where UPPER("CLASTNAME") LIKE 'SMITH%'
every time we run this, oracle does a full table scan, this is bad when we expect to have over 4 million records in this table.
what am I missing or can't we ever use UPPER() with LIKE ???
TIA
Mark
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only