Jet Reports Homepage |  Community Forum |  Downloads |  Submit A Ticket |  Jet Express Support
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 Indexes → Index Settings...


2. Click Add Index


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


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

Comments