RE: Qualifying columns to improve performance?

From: Li, Xiangli <Xiangli.Li_at_aig.com>
Date: Wed, 18 Apr 2001 07:17:29 -0700
Message-ID: <F001.002EBD3F.20010418071132@fatcity.com>

-----Original Message-----

From:   Arn Klammer [SMTP:Arn.Klammer_at_austrac.gov.au]
Sent:   Monday, April 02, 2001 10:30 PM
To:     Multiple recipients of list ORACLE-L

Subject:        Qualifying columns to improve performance?

At a course some years ago, we were told that in join statements, we should qualify ALL our column names with the appropriate table name, not just those that may be ambiguous. The reason was that the parser would not need to spend time checking multiple tables to determine the table to which each column belongs.

 

Is this still a valid rule?
 

Does this apply to statements in PL/SQL procedures/packages?  Or are they different, because they are checked at compile time? 

 

-a

---

This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager.

This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses.

www.mimesweeper.com

---

Received on Wed Apr 18 2001 - 09:17:29 CDT