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.