Archives of the TeradataForum

Message Posted: Mon, 10 Sep 2001 @ 18:51:31 GMT

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

I have ment what is in MS SQL Server called Indexed Views. It is that indexes are created upon the views (this is th MS definition).

"If your application needs to access views often, consider adding an unique clustered index to your views to significantly improve performance. When a view is created with a unique clustered index, the view is created along with the clustered index, which is created and stored in the database the same way as a clustered index on a table."

I have used it on SQL, and in Teradata I have found something like (CREATE JOIN INDEX) what I am not sure how it performes.

Thanks,

Igor

PS I don't know, but isn't derived table the same like the option to use a VIEW in JOIN (This view is created the same way as the SELECT statement in the derived table would be written)?

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