× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
tariqrahiman reported 2013-06-12T17:33:01Z  · swissarmyknife(*) last modified 2013-06-20T21:06:20Z

Missing keyword in MSSQL 2012 Column store indexes for ER Model


Priority Major
Complexity Unknown
Component Tools - ER Modeler
Version 13.0

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
2 attachments
  • 2

    2013-06-12T17:33:01Z

    120 KB

  • 1

    2013-06-12T17:33:01Z

    56 KB

Issue #9342

Closed
Fixed
Resolved 2013-06-20T16:24:02Z
 
 
Completion
No due date
Fixed Build v13.0.3-1
No time estimate

About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017