Creates indexes on columns in tables. Restriction: You cannot use CREATE INDEX on a table accessed via an engine ... whether the changes originate from PROC SQL or from some other source. Therefore, ...

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 ...

If indexes are defined on columns in the table, CREATE INDEX statements for those indexes ... writes a view definition to the SAS log. If you use a PROC SQL view in the DESCRIBE VIEW statement that is ...