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.
--------------
BEGIN:VCARD VERSION:2.1 N:Datta;Shantanu FN:Shantanu Datta ORG:Hurix Systems Pvt. Ltd. TITLE:Software Engineer TEL;WORK;VOICE:+91 (22) 692-3888 X 243 TEL;WORK;FAX:+91 (22) 826-5948 ADR;WORK;ENCODING=QUOTED-PRINTABLE:;;231, Solitaire Corporate Park,=0D=0A151, Andheri-Kurla Road,;ANDHERI (E);M= UMBAI, Maharashtra;400093;India LABEL;WORK;ENCODING=QUOTED-PRINTABLE:231, Solitaire Corporate Park,=0D=0A151, Andheri-Kurla Road,=0D=0AANDHERI (E= ), MUMBAI, Maharashtra 400093=0D=0AIndia URL: URL:http://www.hurix.com EMAIL;PREF;INTERNET:[EMAIL PROTECTED] EMAIL;INTERNET:[EMAIL PROTECTED] REV:20020510T085122Z END:VCARD