Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Does the case of an Oracle query statement affect query perfo

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

From: Mercadante, Thomas F <NDATFM_at_labor.state.ny.us>
Date: Mon, 30 Sep 2002 05:48:23 -0800
Message-ID: <F001.004DC4B6.20020930054823@fatcity.com>








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:Rajendra.Jamadagni@espn.com]
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:shantanu.datta@hurix.com]
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.
--------------
 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mercadante, Thomas F
  INET: NDATFM_at_labor.state.ny.us

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 - 08:48:23 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US