Archives of the TeradataForum

Message Posted: Wed, 28 Jan 2009 @ 14:21:43 GMT

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

<-- Anonymously Posted: Wed, 28 Jan 2009 14:16 -->

What could be the best way of optimizing the SQLs which source data from the views?

If TASM is implemented and the query falls in medium queue (execution time between 30 seconds to 20 minutes) but if such a query is based on a view instead then what ways could be used to reduce the execution times?

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