Re: Case sensitive

In article dated 14 Nov 1996 16:42:02 GMT, Jeff Murphy (jcmurphy_at_acsu.buffalo.edu) wrote:
> Antonio Melo (avm_at_novabase.pt) wrote:
> > 2. use " where upper(name) like 'MAR%' " => performance problems...
>
>
> what are the performance implications of using this technique to provide
> case insensitive searches?

Using certain SQL functions will cause a full table scan to be done instead of a index range scan & lookup by rowid.

-- 
 _--_|\  John Verhoeven           Unix / Database Administrator Westrail
/      \              johnv_at_DIALix.oz.au / jverhoeven_at_westrail.wa.gov.au
*_.--._/
      v   "Smile! things could be worse... So I did... and they were..."