Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 20 Jan 2011 @ 15:32:08 GMT

  <Prev Next>   <<First <Prev Next> Last>>  

Subj:   Re: Database View Limits
From:   John_Wight

Dieter's comments are (as always) right on. I might add that, you should also consider NOT using the SELECT * FROM DB.TABLE; syntax as this will cause a lot of extra effort and time when developers/users try to figure out what is in the view, etc. It's easy for a DBA to create a facility to generate those but all the time and effort is not here - but in the access and use of these objects! If you are a DBA have influence on them, don't let them take the easy road - the users (ETL developers, etc.) will suffer in the end.

I would suggest that you always use the following convention for clarity and ease of use, etc.

             column list

Providing this format gives potential users a,l the info they might need without doing further searches to find out what is in * and what order they are, etc.

But again - just the world from where I sit;-)


  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023