Re: Using all uppercase for SQL

[Ethan Kayes <ebkayes@HEWITT.COM>]

To the best of my knowledge this is not true. Most DB optimizers to not care
about the cases of your SQL.
The Ansi SQL-89 specified that there was no difference in syntax between upper,
lower and mix case except in the execution of quoted literals.

SQR interpiter show no differnces in performice the regards to case.




From: Tom Dommermuth <tdommer@PRINCETON.EDU> on 01/31/2001 04:34 PM

Please respond to sqr-users@list.iex.net

To:   SQR-USERS@list.iex.net
cc:
Client:
Subject:  Using all uppercase for SQL



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?