Specifies whether to use an index when processing a WHERE expression in the SPD Engine.
Valid in: | DATA step and PROC step |
Default: | YES |
Restriction: | WHERENOINDEX= option cannot be used with IDXWHERE=NO option |
Engine: | SPD Engine only |
uses an index when processing a WHERE expression.
ignores an index when processing a WHERE expression.
Restriction | You cannot use the IDXWHERE=NO option and the WHERENOINDEX= option together. |
Note: BY ordering was produced by using an index for
table tablename.
Note: BY ordering was produced by performing an
automatic sort on table tablename.
34 options msglevel=i; 35 proc means data=permdata.customer(idxwhere=no); 36 var sales; 37 where state="CA"; 38 run; whinit: WHERE (sstate='CA') whinit returns: ALL EVAL2 NOTE: There were 2981 observations read from the data set PERMDATA.CUSTOMER. WHERE state='CA';
39 proc means data=permdata.customer(idxwhere=yes); 40 var sales; 41 where state="CA"; 42 run; whinit: WHERE (sstate='CA') -- whinit: SBM-INDEX STATE uses 45% of segs (WITHIN maxsegratio 75%) whinit returns: ALL EVAL1(w/SEGLIST) NOTE: There were 2981 observations read from the data set PERMDATA.CUSTOMER. WHERE state='CA';