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

Thread: Alias and join

  1. #1
    Join Date
    Aug 2001
    Posts
    45
    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
    Location
    Virginia, USA
    Posts
    455
    aliases are good, because in real life some table names are very long such as
    AP_TNRCC_TPWD_INBOUND_DEV

  3. #3
    Join Date
    Aug 2001
    Location
    Waterloo, On
    Posts
    547
    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 raminderahluwalia@rediffmail.com.

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