SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

Add an index to a SPDO cluster?

Accepted Solution Solved
Reply
Regular Learner
Posts: 1
Accepted Solution

Add an index to a SPDO cluster?

In the past I have tried to add an index to a SPDO cluster dataset via

PROC DATASETS ... INDEX CREATE

which results in an error. Is there some other way to add an index to a SPDO cluster dataset? Can one possibly create indices on the member datasets before calling

PROC SPDO ... CLUSTER CREATE

and will these then somehow get aggregated into a master index of some kind? Or is indexing simply not possible on clusters?


Accepted Solutions
Solution
‎10-07-2016 06:51 PM
Super User
Posts: 5,255

Re: Add an index to a SPDO cluster?

Indexes must be applied before you are creating the cluster.
All cluster members must have identical indexes.
And no, no master index will be but. During a query, first spds decides which members qualifies. Then, if any where predicates is evaluated to the individual members.
The only master index sort of speak is the minmaxvarlist mechanism which is almost mandatory.
Data never sleeps

View solution in original post


All Replies
Solution
‎10-07-2016 06:51 PM
Super User
Posts: 5,255

Re: Add an index to a SPDO cluster?

Indexes must be applied before you are creating the cluster.
All cluster members must have identical indexes.
And no, no master index will be but. During a query, first spds decides which members qualifies. Then, if any where predicates is evaluated to the individual members.
The only master index sort of speak is the minmaxvarlist mechanism which is almost mandatory.
Data never sleeps
☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 259 views
  • 1 like
  • 2 in conversation