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.

Getting the CREATE INDEX statement is as simple as adding in one more column, shown below, to this query which then generates the T-SQL CREATE INDEX statement. 'USE [' + DB_NAME(c.database_id) ...