Archives of the TeradataForum
Message Posted: Thu, 05 Mar 2009 @ 22:06:54 GMT
We have few tables around 500GB. So when tables are big, we do have spool overhead, isn't it?
In our rapidly growing data warehouse, almost 90% of the operations (Mloads, FastExports, Complex DML queries, Report generation etc) are all setup against databases with base tables and so far no issues. Will there be any advantage(s) if we spend time migrating these operations against views (pointing to base tables)?
REPLACE VIEW REPORTSV.ZIP_CODES AS LOCKING ROW FOR ACCESS SELECT * FROM REPORTS.ZIP_CODES;
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|