Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 22 Sep 2006 @ 17:55:54 GMT


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


Subj:   Advise on creating views
 
From:   naomi

All,

I'm trying to design a solution for my users, who need to see existing data broken out in some new ways. I'm thinking I'll create 6 new views of an existing table, using the where clause of each view to get just the rows I want (e.g. XYZ_Ind = 'X'), and setting the value (in the view) of an indicator column to be A, B, C, D, E, or F, depending on which view it is. (Some rows will belong to more than one view.) Then I'll create one more view which is a UNION of these other views. My users should then do all their querying off the "Union" view.

Is this a good solution? Will it work but, and also is it efficient? Do I need to provide more details?


Thanks in advance.

Naomi



     
  <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: 27 Dec 2016