Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: alias - do i need to use?

Re: alias - do i need to use?

From: Sybrand Bakker <sybrandb_at_hccnet.nl>
Date: Sun, 13 Feb 2005 23:50:17 +0100
Message-ID: <jcmv0118gp44rhd13nqq1oakgtooqbsbl1@4ax.com>


On Sun, 13 Feb 2005 21:56:07 GMT, "Randy Harris" <randy_at_SpamFree.com> wrote:

>Please correct me if I am wrong, but it seems to me I recall having read
>that there is also a slight performance advantage gained by explicitly
>aliasing all of the selected columns, whether a risk of ambiguity exists or
>not.

It would speed up data dictionary look up.

--
Sybrand Bakker, Senior Oracle DBA
Received on Sun Feb 13 2005 - 16:50:17 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US