Indexes enable PROC SQL to execute the following classes of queries more efficiently: comparisons against a column that is indexed. an IN subquery where the column in the inner subquery is indexed.