No, there will not be any noticable difference in performance.
-Mark
On Mon, 2002-09-30 at 03:58, Shantanu Datta wrote:
> 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.
> --------------
>
--
--
Mark J. Bobak
Oracle DBA
mark_at_bobak.net
"It is not enough to have a good mind. The main thing is to use it
well."
-- Rene Descartes
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mark J. Bobak
INET: mark_at_bobak.net
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 - 07:48:19 CDT
