Archives of the TeradataForum

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

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

<-- 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>>