Does aliasing tables names in large queries have noticeable impact on performance?
Aliasing:
...
...
FROM table_1 T1
...
...
...
Is it significantly different for the various DB systems out there?
views:
53answers:
2Only as long as there's no bug in your DBMS: Bad performance when using alias vs. base table in outer join query. (In an older DB2 version: http://www-01.ibm.com/support/docview.wss?uid=swg1IY58735) ;-)
MicSim
2009-08-06 15:11:07
+4
A:
There a discussion about this topic already. In short, there is no significant impact on performance caused by aliasing table names.
Matthew Jones
2009-08-06 14:52:47
Hit by the drive-byes, again. Downvoters, please leave comments, so I can fix what was wrong.
Matthew Jones
2009-08-06 14:56:03
For some reason SQL questions attract a lot of downvotes for making suggestions or just even answering :) I enjoyed the link though so I voted you up.
Jon
2009-08-06 15:05:12