Sign Up for Training |
Jet Global Company Site
Submit a Request
Give Feedback

Creating Columnstore Indexes using the Jet Data Manager


In the Jet Data Manager, you can create Columnstore Indexes to significantly improve performance when querying your large fact tables in typical data warehouse scenarios.


SQL Server Enterprise Edition is required to utilize Columnstore indexes

For a list of supported data types on different SQL Server versions

SQL Server 2012 Columnstore Indexes

SQL Server 2014 Columnstore Indexes

Currently the Jet Data Manager supports the creation of non-clustered Columnstore indexes


1. Select the table on which you wish to place a Columnstore index. Right-click on the table and highlight Advanced, then click on Index Settings.

2. Click Add Index

3. Enter a Friendly Index Name , select Columnstore Index and choose the Index Fields . Click OK once finished.

4. Deploy and Execute the table. 


Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request