Archives of the TeradataForum
Message Posted: Wed, 17 Dec 2003 @ 08:40:43 GMT
| Subj: || || Re: Database Unspecfied? |
| From: || || McCann, Andy |
Along these lines, I believe best practice to be to always fully qualify everything OR use a view layer to make sure you only need point
the job in one place. Having a mix of qualified and unqualified tables and columns can cause problems, especially if there are logic flaws
in the SQL. If you know you are being consistent, you can remove this from the equation should you have to sort out problems.