MSCEWI3074

Create Index Not Supported

This EWI is deprecated. Please see MSCEWI1091 instead.

Severity

High

Description

Create Index statement is not currently supported

Example Code

Input Code:

CREATE UNIQUE INDEX COL1_INDEX ILM (ADD POLICY OPTIMIZE AFTER 10 DAYS OF NO ACCESS) ON CLUSTER CLUSTER1
ONLINE USABLE DEFERRED INVALIDATION;

Output Code:

-- ** MSC-ERROR - MSCEWI3075 - CREATE INDEX NOT SUPPORTED. **
---- CREATE INDEX
--CREATE UNIQUE INDEX COL1_INDEX ILM (ADD POLICY OPTIMIZE AFTER 10 DAYS OF NO ACCESS) ON CLUSTER CLUSTER1
--ONLINE USABLE DEFERRED INVALIDATION

Recommendations