Hello,
Denodo provides two stored procedures [“GENERATE_STATS”](https://community.denodo.com/docs/html/browse/7.0/vdp/vql/stored_procedures/predefined_stored_procedures/generate_stats#generate-stats) and [“GENEARTE_STATS_FOR_FIELDS”](https://community.denodo.com/docs/html/browse/7.0/vdp/vql/stored_procedures/predefined_stored_procedures/generate_stats_for_fields#generate-stats-for-fields) to gather and store statistics of a view. The first one, updates the statistics for all the fields in the view, while the second one updates the statistics for the fields that are specified as input parameters.
You can also refer to the KB article [“How to update the statistics of a view automatically”](https://community.denodo.com/kb/view/document/How%20to%20update%20the%20statistics%20of%20a%20view%20automatically?category=Scheduler) that describes how to update the statistics of a view or multiple views using the stored procedures, GENERATE_STATS and GENERATE_STATS_FOR_FIELDS, and the Denodo Scheduler in order to automate the refresh of statistic.
Hope this helps!