Optimize Table from Table overview

Introduction

In the table overview, you have access to an Optimize option.

Depending on how you use Indexima, the Engine will offer relevant HyperIndexes and remove HyperIndexes that are no longer used.
You can always see what HyperIndexes are added and removed on the Monitor Queries page.

By regularly optimizing your tables, you can guarantee that your BI Queries reach optimal performance. 

Use Optimize in the Table overview

You can use 'Optimize' for three types of optimizations:

Last month tuning

This kind of optimization will take all requests made in the last 30 days.

Last day tuning

This kind of optimization will take all requests made since midnight.

Full optimization

This kind of optimization will take all requests made in the last 30 days.
The HyperIndexes will be fully specialized: they will contain all the expressions coming from the queries.