StarRocks, a Linux Foundation project, is a next-generation sub-second MPP OLAP database for full analytics scenarios, including multi-dimensional analytics, real-time analytics, and ad-hoc queries. StarRocks received InfoWorld’s 2023 BOSSIE Award for best open source software.

StarRocks

After creating and inserting data into a table, does the `information_schema.tables` field `TABLE_ROWS` only get updated when the background statistics job has completed?

Does running an `ANALYZE TABLE table_name` cause an update of that info in the information_schema?

No, the `analyze table` updates the `_statistics_` database, which is used for cost based optimization.

Any idea when the TABLE_ROWS field does get updated? It definitely does, eventually, but not immediately

This is typically done every 5 minutes, by the background process