I finally began my ILT. I am curious about one area, When writing join statement, especially one involving many columns and tables, non-equijoins, I found it to be more legible and less confusing if I write the entire table names instead of using aliases, I know that this takes more memory and more time and performance might suffer, but is this going to be relevant or am I forming a bad habit?
Trying to remain objective, since one can always be wrong.....without knowing it at the moment.
aliases are good, because in real life some table names are very long such as
You have an analytical mind (personal observation).
But one has to use aliases sometimes.
eg. if you use the same table twice(self joins), notwithstanding the example cited above.
IMHO, I don't think performance has got anything to do with it.
[Edited by Raminder on 10-03-2001 at 11:19 AM]
Click Here to Expand Forum to Full Width