Home Page for the TeradataForum

Archives of the TeradataForum

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

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

Subj:   Re: SELECT vs. Temporary Table
From:   Igor Matejov

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)?

  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023