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.
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.