Archives of the TeradataForum

Message Posted: Tue, 18 Dec 2007 @ 16:07:12 GMT

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

All,

You may have already seen this and might know what causes this, so I am looking for help as to why this would happen. When I run an explain on ?select * from the view? I get a different explain than when I run it on the Select statement of the view. Any idea why this would happen?

I have a view which joins 15 tables and the view looks like the following (at a very high level):

     REPLACE VIEW as ViewName

     (
     Col1,
     Col2,
     .
     .
     .
     .
     ColN
     )
     AS
     SELECT
     A as Col1,
     B as Col2,
     .
     .
     .
     .
     Z as Col N
       From
     Table 1
     Inner join Table 2
     On conditions
     .
     .
     .
     .
     Inner join Table 15
     On Conditions;

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