Archives of the TeradataForum
Message Posted: Fri, 22 Sep 2006 @ 17:55:54 GMT
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|