You can either do a "sel *" or if there are rows you do not want to be included go for a "sel * where XYZ_IND in (A,B,C,D,E). You'll be better off versus a "union" view." />

Archives of the TeradataForum

Message Posted: Fri, 22 Sep 2006 @ 22:25:13 GMT


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

Subj:		Re: Advise on creating views

From:		Christian Schiefer, makeITdone

Hi,

nothing against creating different views on the table. You may even partition the table on XYZ_IND, which will give you performance improvement.

Creating a "union"-view on to collect the rows of one table together is not a good idea --> You can either do a "sel *" or if there are rows you do not want to be included go for a "sel * where XYZ_IND in (A,B,C,D,E). You'll be better off versus a "union" view.

Christian/Vienna

www.makeitdone.com