https://communities.sas.com/t5/SAS-Data-Management/Add-an-index-to-a-SPDO-cluster/m-p/303251#M8607 <P>In the past I have tried to add an index to a SPDO cluster dataset via</P><PRE>PROC DATASETS ... INDEX CREATE</PRE><P>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</P><PRE>PROC SPDO ... CLUSTER CREATE</PRE><P>and will these then somehow get aggregated into a master index of some kind? Or is indexing simply not possible on clusters?</P> Fri, 07 Oct 2016 18:41:00 GMT shabbybanks 2016-10-07T18:41:00Z https://communities.sas.com/t5/SAS-Data-Management/Add-an-index-to-a-SPDO-cluster/m-p/303251#M8607 <P>In the past I have tried to add an index to a SPDO cluster dataset via</P><PRE>PROC DATASETS ... INDEX CREATE</PRE><P>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</P><PRE>PROC SPDO ... CLUSTER CREATE</PRE><P>and will these then somehow get aggregated into a master index of some kind? Or is indexing simply not possible on clusters?</P> Fri, 07 Oct 2016 18:41:00 GMT https://communities.sas.com/t5/SAS-Data-Management/Add-an-index-to-a-SPDO-cluster/m-p/303251#M8607 shabbybanks 2016-10-07T18:41:00Z https://communities.sas.com/t5/SAS-Data-Management/Add-an-index-to-a-SPDO-cluster/m-p/303319#M8608 Indexes must be applied before you are creating the cluster.<BR />All cluster members must have identical indexes.<BR />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.<BR />The only master index sort of speak is the minmaxvarlist mechanism which is almost mandatory. Fri, 07 Oct 2016 22:24:29 GMT https://communities.sas.com/t5/SAS-Data-Management/Add-an-index-to-a-SPDO-cluster/m-p/303319#M8608 LinusH 2016-10-07T22:24:29Z