Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 20 Oct 2006 @ 17:19:00 GMT

  <Prev Next>  
Next> Last>>  

Subj:   Question about performance for Views Vs Tables.
From:   Anomy Anom

<-- Anonymously Posted: Friday, October 20, 2006 13:17 -->

Hello Experts,

I have one question about performance for Views Vs Tables.

In our current production system we have Table database (say TableDB) and view database (say ViewDB). In ViewDB we have one to one views based on tables from tableDB.

     Create View ViewDB.View1
     Lock Table TableDB.Tbl1 FOR ACCESS
     SELECT *
     FROM TableDB.Tbl1;

As per our new business requirement, we need to create join views (data based one different tables.). Say new view ViewJt requires data from Tbl1, Tbl2, Tbl3.

My question is what will be the best way to build this new join view? Joining directly tables from TableDB or one to one views from ViewDB. Which way we will get best performance? Or it doesn't matter if we use Table or 1-1 views? What is the best practice?

Thanks in advance

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