Page History

...

There are two approaches to enhance statistics for the planner, one is to introduce the "ANALYZE TABLE" syntax which will write the analyze analyzed result to the catalog, another is to introduce a new connector interface which allows the connector itself to report statistics directly to the planner. The second one is a supplement to the first onecatalog statistics.

The main purpose of this FLIP is to disucss discuss the second approacheapproach. Compared to the first approacheapproach, the second one is to get statistics in real time, no need to run analyze an analysis job for each table. This could help improve the user experience. The disadvantage is, in most cases, the statistics reported by connector is not as complete as the results of analyze analyzed job. We will also introduce the "ANALYZE TABLE" syntax in other FLIP.

...