What is a Smart Table

A smart table is a SQL table with the capacity to create and remove indexes by itself! There is no need to run the Analyzer since it would be running automatically.

How Smart Table works

Of all tables provided to BI users, how would you choose the tables to be optimized first?

Each smart table will get a score (based on Execution time, usage of Kstore indexes, ...). This notation leads to the list of tables that need to be optimized first.

The engine will optimize the most needed tables within a time frame you can specify. You can then choose the type of analysis that you want to run on each table using optimized_index.json. 

Define the Smart Mode for a table

By default

By default, the smart mode is DEFAULT.

DEFAULT is defined by the administrator when configuring the Smart Tables.

Through the indexima interface

In the Indexima Console, you can turn a table into a smart table in the Table 'Overview' by choosing an option in 'Smart Optimizers' .

Through SQL

Use the SQL command OPTIMIZER (Analyzer mode) to change the analyzer mode.

Activate & Define timeframe

Go to Smart Tables Activation & configuration.