Archives of the TeradataForum
Message Posted: Thu, 05 Mar 2009 @ 21:34:52 GMT
Not sure if much more detail is required. Teradata does not read the data out of a table, put it into spool and then select from it - no additional spool overhead required.
If you where to do the following:
EXPLAIN sel columns from tablename
EXPLAIN sel columns from viewname /* assumes view of columns & rows */
there is no difference in the output to the point that the view name does not appear anywhere in the output from the EXPLAIN
so if the original select would use an index the view would use the index doing the same select.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|