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

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