Archives of the TeradataForum

Message Posted: Thu, 05 Mar 2009 @ 21:34:52 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

madhu das:

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

or

     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.

Regards,

Michael Larkins
Certified Teradata Master
Certified Teradata SQL Instructor

	<Prev	Next>		<<First	<Prev	Next>	Last>>