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

From: Deshpande, Kirti <kirti.deshpande_at_verizon.com>
Date: Mon, 30 Sep 2002 06:08:29 -0800
Message-ID: <F001.004DC535.20020930060829@fatcity.com>

Oracle sees (a) and (b) as two different queries and parses them both. For them to be identical the text must match, including the white spaces.

I suggest a small test under *identical conditions* to see if execution time varies ;)

- Kirti

-----Original Message-----
From: Shantanu Datta [mailto:shantanu.datta@hurix.com]
Sent: Monday, September 30, 2002 2:58 AM
To: Multiple recipients of list ORACLE-L
Subject: Does the case of an Oracle query statement affect query performance?

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.

--------------

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Deshpande, Kirti
  INET: kirti.deshpande_at_verizon.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).

Received on Mon Sep 30 2002 - 09:08:29 CDT