Alias and join Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Alias and join

  1. #1
    Join Date
    Aug 2001
    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.

  2. #2
    Join Date
    Dec 2000
    Virginia, USA
    aliases are good, because in real life some table names are very long such as

  3. #3
    Join Date
    Aug 2001
    Waterloo, On
    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]

    Raminder Singh

    Oracle Certified DBA: Oracle 8i, 9i

    Mail me at

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width