Archives of the TeradataForum

Message Posted: Fri, 22 Sep 2006 @ 17:55:54 GMT

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

All,

I'm trying to design a solution for my users, who need to see existing data broken out in some new ways. I'm thinking I'll create 6 new views of an existing table, using the where clause of each view to get just the rows I want (e.g. XYZ_Ind = 'X'), and setting the value (in the view) of an indicator column to be A, B, C, D, E, or F, depending on which view it is. (Some rows will belong to more than one view.) Then I'll create one more view which is a UNION of these other views. My users should then do all their querying off the "Union" view.

Is this a good solution? Will it work but, and also is it efficient? Do I need to provide more details?

Thanks in advance.

Naomi

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