1. Add COLUMNSTORE as a keyword
2. Use Tools-> ER Diagram Generator to script the table with COLUMNSTORE. In the ER Model, the icons for indexes are different. (See attached pic 1)
I think we have the icon for clustered index as an ordinary index. If we do display icons for different type of indexes in the ER Model, can you update the same ?
3. Take the index properties of a COLUMNSTORE index and you can see that the COLUMNSTORE keyword is missing. (See attached pic 2)
Generate Script from Diagram is missing COLUMNSTORE keyword in ER Model.
I used below script to create the table and indexes :
CREATE TABLE SimpleTable (ProductKey [int] NOT NULL, OrderDateKey [int] NOT NULL, DueDateKey [int] NOT NULL, ShipDateKey [int] NOT NULL); GO CREATE CLUSTERED INDEX cl_simple ON SimpleTable (ProductKey); GO CREATE NONCLUSTERED COLUMNSTORE INDEX csindx_simple ON SimpleTable (OrderDateKey, DueDateKey, ShipDateKey); GO
added to keywords for ms sql server
added columnstore options to ERM. icons have not changed
added columnstore options to ERM. icons have not changed
We have a fix for this:
We have a fix for this:
Issue #9342 |
Closed |
Fixed |
Resolved |
Completion |
No due date |
Fixed Build v13.0.3-1 |
No time estimate |
1 issue link |
relates to #9325
Issue #9325Add support for MSSQL 2012 Column store indexes and table compression |
added to keywords for ms sql server