Re: Indexing & text fields

From: Ed Bruce <edward_at_igate1.hac.com>
Date: 1995/09/20
Message-ID: <edward-2009951435410001_at_r-618macip18.hac.com>#1/1

In article <edward-1909951543080001_at_r-618macip18.hac.com>, edward_at_igate1.hac.com (Ed Bruce) wrote:

>
> select string
> from line, words
> where upper(word) = upper('Hello')

            ^^^^^^    ^

Already commenting on my own suggestion. Well who else noticed that by using the upper function the WHERE clause can not use the index on word. Oh well. Just store the parsed word into the column in upper case and change the where to

     where word = upper('Hello')

> and words.sequence = line.sequence;
>
> No guarantee this will work. But I think it is a place to start.

Well it may have worked, but it would have defeated the index.

-- 
Ed Bruce
edward_at_igate1.hac.com
Key fingerprint =  62 8D FC 8F 27 2F 89 D0  8B 38 7E 34 33 74 C2 36

Received on Wed Sep 20 1995 - 00:00:00 CEST