Why not try the two (one with qualifiers and one
without) and trace each - on a freshly started
database...
See how much additional recursive sql occurs (if any)
hth
connor
--- Arn Klammer <[EMAIL PROTECTED]> wrote: >
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
>
**********************************************************************
>
=====
Connor McDonald
http://www.oracledba.co.uk (mirrored at
http://www.oradba.freeserve.co.uk)
"Some days you're the pigeon, some days you're the statue"
____________________________________________________________
Do You Yahoo!?
Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk
or your free @yahoo.ie address at http://mail.yahoo.ie
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: =?iso-8859-1?q?Connor=20McDonald?=
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).