Re: Please Help

From: Stewart Burnett <Stewart_at_burnettms.nospam.demon.co.uk>
Date: Wed, 16 Dec 1998 16:58:31 -0000
Message-ID: <758orf$bep$1@hagen.cloud9.co.uk>

Note that using upper on a column name disables the use of indexes and therefore takes longer. One solution I have used in the past is to create a new indexed column for the table called, say, upper_name and use a before insert/update trigger to populate this with upper(name). You can then change the select to;

SQL> select * from a where upper_name = upper('wood');

which will use the index on upper_name.

Erika Grondzakova wrote in message <36777D92.70B8BC82_at_cern.ch>...
>
>SQL> select * from a where upper(name) = upper('WOOD');
>
> ID NAME
>--------- -----------
> 4 Wood
>
>Erika
>
Received on Wed Dec 16 1998 - 10:58:31 CST