How do you set up or exploit an index on a mixed-case char. field
(such as a name or address) so that you can have fast CASE
INSENSITIVE queries?
In some languages, the technique is to add an index on the mixed-case
field as UPPER(fieldname), then force any query parms to upper case
before executing the query. The database engine then matches the
uppercase parm value to the uppercase index on the field. However, in
Oracle, functions are now allowed in indexes. How do you accomplish
this?
Received on Tue Sep 01 1998 - 09:57:38 CDT
