-
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
AP_TNRCC_TPWD_INBOUND_DEV
-
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]
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|