Tweet
Is there a way to build an SQL index over all members in a multi-member physical file? Alternatively, what are my SQL index options when dealing with a multi-member PF? Thanks in advance for your help.
-
-
Multi-member SQL indexes
howsys wrote: > Is there a way to build an SQL index over all members in a > multi-member physical file? Alternatively, what are my SQL index > options when dealing with a multi-member PF? Thanks in advance for > your help. I haven't tried it, but it seems that if you create Aliases for each member in the table, then create a Union All view over the Aliases, you could then index the view. Bill
Comment