Sign Up for Training |
Jet Express Support |
Jet Reports Company Site
Jet 365 Financials
Jet Professional
Jet Enterprise
Downloads
Community
Submit a Request
Give Feedback

Creating Columnstore Indexes using the Jet Data Manager


Overview

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

Process

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

Comments