"Hopper, Wendy
S" To: Multiple recipients of list
ORACLE-L <[EMAIL PROTECTED]>
Subject: Query tuning with
tablename alias
Sent by:
cal can explain this properly).
Regards,
Mark.
"Hopper, Wendy
S" To: Multiple recipients of list
ORACLE-L <[EMAIL PROTECTED]>
Subject:
S" To: Multiple recipients of list
ORACLE-L <[EMAIL PROTECTED]>
Subject: Query tuning with
tablename alias
Sent by:
[EMAIL PROTECTED]
ED]]Sent: Wednesday, November 20, 2002
1:13 PMTo: Multiple recipients of list ORACLE-LSubject:
Query tuning with tablename alias
Hello
list.
I have recently
been tasked with trying to optimize some slow performing queries (Oracle
8.1.7) for an application that generates
Regards,
Mark.
"Hopper, Wendy
S" To: Multiple recipients of list
ORACLE-L <[EMAIL PROTECTED]>
Subject: Query tuning with
tablename alias
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]>
Subject: Query tuning with tablename
alias
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
metho
Title: Message
Hello
list.
I have recently been
tasked with trying to optimize some slow performing queries (Oracle 8.1.7) for
an application that 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
