Re: Case Insensitive Searches In Oracle

Chuck Erickson wrote:

>
> - SELECT * FROM EMP WHERE UPPER('smith') = UPPER(EMP_NAME) does not
> use
> an index and thus does a full table scan each time.
>

Hmmm. This is a major problem with most relational databases. I am running
Informix Universal Server and there you can do some nifty things:

CREATE INDEX upper_ix ON emp ( UPPER(emp_name));

Then queries like the one above would use this index.

-- 
Snorri Bergmann                    | Mail:       snorri_at_strengur.is
Strengur Consulting Engineers      | WWW:        http://www.strengur.is/
Armuli 7                           | Phone:      +354 550 9000 (9007
direct)
108 Reykjavik Iceland              | Telefax:    +354 550 9010