Title: Message
Hello
list.
I have recently been
tasked with trying to optimize some slow performing queries (Oracle 8.1.7) for
an applicationthat generates reports in a data warehouse type
environment. I have noticed in most of the queries that the table names
have been aliased, but not
Wendy - I think the difference between using an alias or not is negligible.
My reasoning is that this would be easy to test (good idea if you have a
moment) and there are enough picky Oracle developers that if this was not
negligible, people would have been bragging about this as their secret
Subject: Query tuning with tablename
alias
Sent by:
[EMAIL PROTECTED
Title: RE: Query tuning with tablename alias
but if you provide hints on such statements, you better be using aliases for hints .
Aliases are used for readability ... you either use the aliases or user tablename.column but not both ... world is already confusing enough ...
Raj
.
Hopper, Wendy
S To: Multiple recipients of list
ORACLE-L [EMAIL PROTECTED]
wendy.hopper@ cc:
eds.com Subject: Query tuning with
tablename alias
:
"DUAL"."DUMMY": invalid identifier
SQL select dual.dummy from dual;
D-X
Waleed
-Original Message-From: Hopper, Wendy S
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, November 20, 2002
1:13 PMTo: Multiple recipients of list ORACLE-LSubject:
Query tuning with tab
To: Multiple recipients of list
ORACLE-L [EMAIL PROTECTED]
wendy.hopper@ cc:
eds.com Subject: Query tuning with
tablename alias
Sent by:
[EMAIL PROTECTED
this properly).
Regards,
Mark.
Hopper, Wendy
S To: Multiple recipients of list
ORACLE-L [EMAIL PROTECTED]
wendy.hopper@ cc:
eds.com Subject: Query tuning
S To: Multiple recipients of list
ORACLE-L [EMAIL PROTECTED]
wendy.hopper@ cc:
eds.com Subject: Query tuning with
tablename alias
Sent