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

[Mercadante, Thomas F]

Raj,

 

Do you have any test cases or white papers to support your statement?  Especially the part about

 

"if you mix-n-match that will make Oracle do more work."

 

never heard of this before and I am interested if it is true.

Tom Mercadante
Oracle Certified Professional

-----Original Message-----
From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 30, 2002 8:33 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Does the case of an Oracle query statement affect query perfo

As long as you stick to either (a) or (b) you will be okay ... if you mix-n-match that will make Oracle do more work.

 

Raj

______________________________________________________

Rajendra Jamadagni              MIS, ESPN Inc.

Rajendra dot Jamadagni at ESPN dot com

Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.

QOTD: Any clod can have facts, but having an opinion is an art!

-----Original Message-----
From: Shantanu Datta [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 30, 2002 3: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.

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