This is a deprecated version of the SnowConvert documentation, please visit the official site .
This EWI is deprecated. Please see 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