Re: Please HELP

From: Jim Lyons <j.lyons_at_cc.utexas.edu>
Date: Wed, 16 Dec 1998 16:42:51 -0600
Message-ID: <3678376B.670@cc.utexas.edu>

mike_pinker_at_iint.com wrote:

> Yes, the solution would work but using UPPER(THENAME) in the WHERE clause
> would prohibit the use of any index on the THENAME column ( forcing a full
> table scan). You could add another column called THENAME_UPPER which is
> populated with the THENAME in capitals on insert ( e.g. by a trigger ). Index
> this column and you could then use the select below:
>
> SELECT * FROM MYTABLE WHERE THENAME_UPPER LIKE '%WOOD%';
Would an index be used in a LIKE comparison which is not anchored at the start? I believe "... LIKE 'WOOD%'" could use an index but not "...LIKE '%WOOD%".

--

Jim Lyons                     |  Operating Systems Specialist
ACITS                         |  512-475-9331

University of Texas at Austin | j.lyons_at_cc.utexas.edu http://uts.cc.utexas.edu/~jlyons Received on Wed Dec 16 1998 - 16:42:51 CST