SPD EngineでのWHERE式処理時にインデックスを使用するかどうかを指定します。
該当要素: | DATAステップおよびPROCステップ |
デフォルト: | YES |
制限事項: | WHERENOINDEX=オプションはIDXWHERE=NOオプションと一緒には使用不可 |
エンジン: | SPD Engineのみ |
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';