Archives of the TeradataForum
Message Posted: Thu, 05 Mar 2009 @ 22:44:49 GMT
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|