Re: Case insensitive queries

From: Hans Forbrich <forbrich_at_tyahoo.net>
Date: Sat, 29 Nov 2003 06:32:42 GMT
Message-ID: <3FC83D7C.A99C243E@tyahoo.net>

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'.

(Lousy design is never a possible source of problems. Similar to 'security? naw, no time now! we'll do it later, maybe in production. shouldn't have an impact.') Received on Sat Nov 29 2003 - 00:32:42 CST