Return-Path: Received: from ensim.rackshack.net (root@localhost) by orafaq.net (8.11.6/8.11.6) with ESMTP id g8UFx8j11526 for ; Mon, 30 Sep 2002 10:59:13 -0500 X-ClientAddr: 209.68.248.164 Received: from newsfeed.cts.com (newsfeed.cts.com [209.68.248.164]) by ensim.rackshack.net (8.11.6/8.11.6) with ESMTP id g8UFx8e11519 for ; Mon, 30 Sep 2002 10:59:08 -0500 Received: from fatcity.UUCP (uucp@localhost) by newsfeed.cts.com (8.9.3/8.9.3) with UUCP id GAA04152; Mon, 30 Sep 2002 06:42:01 -0700 (PDT) Received: by fatcity.com (26-Feb-2001/v1.0g-b72/bab) via UUCP id 004DC4B6; Mon, 30 Sep 2002 05:48:23 -0800 Message-ID: Date: Mon, 30 Sep 2002 05:48:23 -0800 To: Multiple recipients of list ORACLE-L X-Comment: Oracle RDBMS Community Forum X-Sender: "Mercadante, Thomas F" Sender: root@fatcity.com Reply-To: ORACLE-L@fatcity.com Errors-To: ML-ERRORS@fatcity.com From: "Mercadante, Thomas F" Subject: RE: Does the case of an Oracle query statement affect query perfo Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 72; ListGuru (c) 1996-2001 Bruce A. Bergman Precedence: bulk Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C2687F.B0C1DAE8" ------_=_NextPart_001_01C2687F.B0C1DAE8 Content-Type: text/html; charset="iso-8859-1"

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.

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

------_=_NextPart_001_01C2687F.B0C1DAE8-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F INET: NDATFM@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@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).