Re: Case sensitive

From: valerie_webster <val_at_dd.dd.dd>
Date: 1996/11/18
Message-ID: <01bbd556$4a8ed900$5e0285c1@pc363.qsp.co.uk>#1/1

Jeff Murphy <jcmurphy_at_acsu.buffalo.edu> wrote in article <56fi4q$s9o_at_prometheus.acsu.buffalo.edu>...
> 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?
>

Jeff,

Implications are that Oracle will not use any index that has been defined for the column 'name'.

Steve Received on Mon Nov 18 1996 - 00:00:00 CST