Gather Statistics fails in 80 seconds

HI. I am testing using Denodo Express 7.0. I am collecting statistics for a derived view, but I get an error in 80.001 seconds. Is this because Express? Or is it a standard specification of Denodo? Best Regards.
user
07-11-2019 23:42:31 -0500

1 Answer

Hi, I have created a derived view and am able to gather statistics without any error. I would like to clarify you that statistics gathering is not imposed in [Limitations of the Denodo Express License](https://community.denodo.com/docs/html/browse/7.0/platform/installation/appendix/limitations_of_the_denodo_express_license/limitations_of_the_denodo_express_license#limitations-of-the-denodo-express-license). However, the gathering statistics process has [limitations](https://community.denodo.com/docs/html/browse/6.0/vdp/administration/optimizing_queries/cost-based_optimization/gathering_the_statistics_of_views#limitations-of-the-gathering-statistics-process) that you should take into account in order to use the cost based optimization. You could also take a look at the section [how the gathering statistics process works](https://community.denodo.com/docs/html/browse/7.0/vdp/administration/optimizing_queries/cost-based_optimization/gathering_the_statistics_of_views#how-the-gathering-statistics-process-works) of Virtual DataPort Administration Guide for more information. Hope this helps!
Denodo Team
08-11-2019 08:08:23 -0500
You must sign in to add an answer. If you do not have an account, you can register here