Archives of the TeradataForum
Message Posted: Mon, 10 Sep 2001 @ 18:51:31 GMT
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.
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)?
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|