Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 18 Nov 2004 @ 09:57:23 GMT


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


Subj:   Nested Views & Spool
 
From:   Anomy Anom

<-- Anonymously Posted: Wednesday, November 17, 2004 18:05 -->

Does nested views have any affect on running out of spool? I am joining 2 views together and am running out of spool space. When I take a closer look I notice that both views are actually nested about 3 layers deep from the base table.

Example:

     Create Table base1
        Col a
        Col b
        Col c

     Replace View V1
     As Select * from base1

     Replace View V2
       As Select * from V1

     Replace View V3
       As Select * from V2

     Create Table base2
        Col a
        Col b
        Col c
        Col e
        Col f
        Col g

     Replace View V4
     As Select Col a, Col e, Col f from base2

     Replace View V5
       As Select * from V4

     Replace View V6
       As Select * from V5


     Select * from V6, V3
     Where V6.Col a = V3.Col a


     
  <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