Re: Using all uppercase for SQL

[the dragon <ceprn@HOTMAIL.COM>]

>From an Oracle standpoint, this is partially a correct statement, but only
to the point where it relates to uniformity.  The compiler will execute a
sql statement faster if it looks *exactly* like a statement it already has
in memory, regardless of the case - for example:

select sysdate from dual; (first execution)
select sysdate from dual; (second execution)

the second execution will run faster, because it has already been compiled.
However, if you change even 1 character, even a space added, then the sql
has changed, and it will have to recompile again.

So then, from a consistency viewpoint, if you have the above all in upper
case, it will execute faster on subsequent executions as long as it is
exactly the same.

This is from oracle optimization class for v6.0...  I assume it has remained
this way.

clark 'the dragon' willis
dragon enterprises, consulting services


----Original Message Follows----

Hi Tom,

To the best of my knowledge there is nothing about the case that
increases or decreases efficiency but I do know that MS SQL Server is
case sensitive so if you are writing code that will be used on different
platforms you should write it all in uppercase.

Cameron

Tom Dommermuth wrote:

 > Someone told me that we should type all of our SQL code in SQRs in
 > uppercase so that the SQL commands are processed more efficiently.
 > Anyone heard of this?

_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com