Statistics

the optimal execution plan for an SQL query and the current data. The syntax is:

analyzeStatistics=
ANALYZE STATISTICS FOR
	[TABLE table_name]
	| [ALL TABLES];

This process scans the full table and generates internal statistics that are persisted. The length of this process depends on the size of the table since it iterates the whole table, row per row. We recommend it to do it periodically and after a massive data ingestion. A rule of thumb is when the accumulated changes since the last running of the statistics reach 10% of the data then the statistics should be run.