RE: Does the case of an Oracle query statement affect query

Well, if oracle stores all the meta data in UPPERCASE, then for a query in which object names are written in lowercase characters will force the parser to convert it into UPPERCASE for comparison, in which case there should be a negligible difference if the name of the objects referenced by the query is written in UPPERCASE.

But that should be so negligible, that it can be safely and wisely ignored

Regards
Naveen

-----Original Message-----
Sent: Monday, September 30, 2002 6:18 PM To: Multiple recipients of list ORACLE-L

No, there will not be any noticable difference in performance.

-Mark
On Mon, 2002-09-30 at 03:58, Shantanu Datta wrote:
> Hi,
> Pardon me for such a naive question, coz I am a novice when it comes to
> Oracle. This is basically got to do with how Oracle parses a query.
>
> Consider the following queries:
>
> a) SELECT column1, column2 FROM table WHERE column0 = 5;
>
> b) SELECT COLUMN1, COLUMN2 FROM TABLE WHERE COLUMN0 =5;
>
> Scenario 1: I use the naming convention a) for ALL my queries
>
> Scenario 2: I use the naming convention b) for ALL my queries
>
> Will there be any difference in the execution time of the same queries
> in Scenario 1 vs 2?
>
> Thanx in advance,
> Shantanu.
> --------------
>

-- 
--
Mark J. Bobak
Oracle DBA
mark_at_bobak.net
"It is not enough to have a good mind.  The main thing is to use it
well."
 						-- Rene Descartes
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mark J. Bobak
  INET: mark_at_bobak.net

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Naveen Nahata
  INET: naveen_nahata_at_mindtree.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).