Archives of the TeradataForum

Message Posted: Wed, 01 Dec 2004 @ 21:38:35 GMT

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

Ulrich,

I like your idea...I'm wondering why we didn't try this approach...it seems easier and cleaner than using a second table.

Regarding statistics; however, I'll still have a problem when I try and join view A_Current.ColA to another table because the optimizer has no stats on the ColA (since it is built in spool by coalescing the base table and the shadow table.)

Thanks,

Clay

Claybourne L. Barrineau
Senior Application DBA
Coca-Cola Enterprises, Inc.

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