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