From: Ian Cary <cary@gatwick.geco-prakla.slb.com>
Subject: Re: case INsensitive queries
Date: 1997/10/10
Message-ID: <343E19F8.D6EBE8FC@gatwick.geco-prakla.slb.com>#1/1
References: <6124s8$6p3$1@newsfep1.sprintmail.com> <cnIRrDAPXmN0EwBL@incads.demon.co.uk>
Organization: Geco-Prakla
Newsgroups: comp.databases.oracle.server



 There has been quite a bit of discussion on this subject recently with the
general solutions being variants on  the quite correct

where upper(column) = upper(input)

I apologise to those of you who already know this,
but I felt that I must point out that constructs of this type
i.e. function(column) do NOT use an index and can have pretty poor performance
depending on the size of table to be searched and the number of distinct column
values.

Regards,

Ian