SqlDbx Forum

SqlDbx

You are not logged in.

#1 2021-01-25 12:31:35

HypoDBA
Member

Scripting Columnstore Index Bug

When scripting a table with a column store index, it is building the DDL as a regular index, example:

From SqlDbx 6.04:

CREATE INDEX [NonClusteredColumnStoreIndex-20191114-075458]
    ON cw.ActiveDayServed (orkidsid, Date_Served)
    WITH (ALLOW_ROW_LOCKS = OFF, ALLOW_PAGE_LOCKS = OFF)
GO

From SSMS 18.7.1:

/****** Object:  Index [NonClusteredColumnStoreIndex-20191114-075458]    Script Date: 1/25/2021 8:22:57 AM ******/
CREATE NONCLUSTERED COLUMNSTORE INDEX [NonClusteredColumnStoreIndex-20191114-075458] ON [cw].[ActiveDayServed]
(
    [orkidsid],
    [Date_Served]
)WITH (DROP_EXISTING = OFF, COMPRESSION_DELAY = 0) ON [PRIMARY]
GO

Thank you for your attention to this issue.

Offline

Board footer

Powered by FluxBB