Archives of the TeradataForum
Message Posted: Fri, 20 Oct 2006 @ 17:19:00 GMT
<-- Anonymously Posted: Friday, October 20, 2006 13:17 -->
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
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|