 |
 |
Archives of the TeradataForum
Message Posted: Thu, 05 Mar 2009 @ 22:44:49 GMT
| Subj: | | Re: Data access using views |
| |
| From: | | Curley, David |
Views can be better b/c they let you force access locking for all user queries.
Views can be worse b/c they can make it harder for users to get at table stats and physical design to check PI and partitioning.
Views can be a lot worse if they contain casting, joins or other transformations, which can prevent queries from being resolved against the
underlying table.
Dave
| |
