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).