MSCEWI3074

Create Index Not Supported

This is a deprecated version of the SnowConvert documentation, please visit the official site HERE.

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

• No end-user actions are required.

• If you need more support, you can email us at [email protected]