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.
--
Galen Boyer
Received on Sat Nov 29 2003 - 09:20:08 CST
