Option to Test Performance

NOINDEX=

Specifies whether to use the table's indexes when processing WHERE clauses.
Syntax
NOINDEX=YES|NO
Default: NO
Arguments
YES
ignores indexes when processing WHERE clauses.
NO
uses indexes when processing WHERE clauses.
Description
Set NOINDEX= to YES to test the effect of indexes on performance or for specific processing. Do not use YES routinely for normal processing.
Example
We created an index for the SEX column but decide to test whether it is necessary for our PROC PRINT processing. Specify for the server not to use the index.
data sport.maillist;
   input
     name $ 1-20
     address $ 21-57
     phoneno $ 58-69
     sex $71;

  datalines;

Douglas, Mike       3256 Main St., Cary, NC 27511        919-444-5555 M
Walters, Ann Marie  256 Evans Dr., Durham, NC 27707      919-324-6786 F
Turner, Julia       709 Cedar Rd., Cary, NC 27513        919-555-9045 F
Cashwell, Jack      567 Scott Ln., Chapel Hill, NC 27514 919-533-3845 M
Clark, John         9 Church St.,  Durham, NC 27705      919-324-0390 M
;

PROC DATASETS lib=sport nolist;
  modify maillist;
  index create sex;
  quit;

/*Turn on the macro variable SPDSWDEB */
/* to show that the index is not used */
/* used during the table processing. */

%let spdswdeb=YES;

title All Females from Current Mailing List;
PROC PRINT data=sport.maillist(noindex=yes);
where sex=F;
run;