Re: Case insensitive queries

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Sat, 29 Nov 2003 08:46:16 -0800
Message-ID: <1070124406.415506@yasure>

Galen Boyer wrote:

> On Sat, 29 Nov 2003, forbrich_at_tyahoo.net wrote:
>

>>Daniel Morgan wrote:
>>
>>>What is it you think Oracle is doing under the covers to make
>>>case insensitive queries possible? Give it some thought. There
>>>is no other way to compare byte values than to alter them. A
>>>switch in the init.ora does not change what is happening.
>>
>>But if it's done at the DB level, the developers can correctly
>>state that the performance issue is not theirs.  Thereby
>>shedding their responsibility in the name of doing it 'at
>>internet speed'.

>
>
> I don't have to consider whether an index works. How come the
> database gives me that? I guess Daniel Morgan has suggest to his
> students since indexes arrived, to not employ them.
>

Indexes provide real value not achievable by any other means. That is not in this case. We've been doing case insensitive queries in Oracle since the 80s.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)

Received on Sat Nov 29 2003 - 10:46:16 CST