SAS 9.4 SQL Procedure User's Guide, Second Edition, 2nd Edition

• In general, indexing on a column with a small number (less than 6 or 7) of distinct

values does not result in a performance gain.

• You can use the same column in a simple index and in a composite index. However,

for tables that have a primary key integrity constraint, do not create more than one

index that is based on the same column as the primary key.

Deleting Indexes

To delete an index from a table, use the DROP INDEX statement. The following DROP

INDEX statement deletes the index Places from NewCountries:

proc sql;

drop index places from sql.newcountries;

Deleting a Table

To delete a PROC SQL table, use the DROP TABLE statement:

proc sql;

drop ...