Hi Team
We are on 7.0.14 MemSQL version and since MemSQL supports Auto stats feature in 7.0.x we have enabled autosats script across all the tables in cluster.
Is there any maintenance activity i need to perform after enabling auto stats.
Is there any direct query to check when the stats got updated for a specific table?
i checked catalog tables but no luck.
Once you enable autostats, the MemSQL engine will automatically gather statistics; there is no maintenance activity that you need to perform.
You can view the column statistics last collected by querying the information_schema.OPTIMIZER_STATISTICS table.
For best performance, most customers run ANALYZE on their tables after their daily data loads to re-optimize their query plans.