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.
Unconfigured Ad Widget
Collapse
Announcement
Collapse
No announcement yet.
Multi-member SQL indexes
Collapse
X
-
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