Re: How to optimize this query?

From: WiseGuy <kanucme_at_notyet.com>
Date: Wed, 13 Aug 2003 19:52:42 -0400
Message-ID: <S1A_a.11427$xQ1.9257@fe05.atl2.webusenet.com>

You must be psychic... yes I am a tea drinker..... however the posting I saw said nothing other than How to optimize this query.... nothing more.... guess I didn't see it in the tea leaves after all.

Though I appreciate your response all the same.

:o)

On Tue, 12 Aug 2003 22:23:03 +0200, Billy Verreynne <dev_at_null.com> wrote:

>WiseGuy wrote:
>
>> Have you considered creating a function index using SOUNDEX, and then
>> performing a soundex query instead ?
>>
>> SELECT
>> count(*)
>> FROM t
>> WHERE soundex(surname) = soundex('SMITH');
>
>Er.. point being? What does this have to do with the OP's problem and
>subsequent discussion on index range scans?
>
>Don't tell me. You're a tea drinker.. <sigh>
>
>;-)

MylxHQ - Oracle Resource Portal
http://oracle.mylxhq.com
bsc7080mqc_at_mylxhp.com
(replace mylxhp with mylxhq to reply/contact) Received on Wed Aug 13 2003 - 18:52:42 CDT