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:[EMAIL PROTECTED]]
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?
From: Shantanu Datta [mailto:[EMAIL PROTECTED]]
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.
--------------