Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 11 Jul 2008 @ 16:38:02 GMT

  <Prev Next>  
Next> Last>>  

Subj:   Pros & Cons Of Complex Views In a Production / Batch Area
From:   Parry, Graham

In our production / batch area we currently try to keep to simple production views with every table having an equivalent SELECT * view over it.

Any code that is executed is through mainframe jobs using one or more work tables to build up the data to the final required position which is accessed via a simple view over it. This is a situation that the support area is comfortable with regards to supporting the processing.

We are now getting requests to use complex views, which are effectively moving code out of the mainframe jobs into the view and generally no longer using temporary tables to build up the data.

I am trying to look at the pro’s and cons of each method to help decide when it is appropriate to use a complex view in production / batch and when it is appropriate to use work tables and mainframe jobs. Obviously, performance, maintenance and the ease of support are major factors in any decision and it may be that a mixture of both methods is appropriate.

Does anyone have any opinions / experience they could share?



Graham Parry
Teradata DBA

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