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
[EMAIL PROTECTED]
"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: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

Reply via email to