You can translate the question and the replies:

Incomplete statistics in the following nodes

Hi Team, I'm facing an issue on gather stats. when i ran a query and gone through execution trace, I can see Optimizer message 'Incomplete statistics in the following nodes' and showing some base view names. i'm getting same message even after gathering stats for all base views. i can see updated stats at view>options>Statistics. Why optimiser is not considering gathered stats? Please help me on this.
user
09-07-2020 03:03:03 -0400

1 Answer

Hi, *Incomplete statistics in the following nodes* message may occur in execution trace when any views falls under [limitations of the Gathering Statistics Process](https://community.denodo.com/docs/html/browse/latest/vdp/administration/optimizing_queries/cost-based_optimization/gathering_the_statistics_of_views#limitations-of-the-gathering-statistics-process). **For example,** One of the limitations of gathering statistics is, in Microsoft SQL Server, statistics are not collected for table fields of the data types TEXT and NTEXT. So, if I create a view which has one integer and one text field of SQL Server and then gather statistics and execute the view, I could see the *Incomplete statistics in the following nodes* message in trace as expected. Hope this helps!
Denodo Team
09-07-2020 07:15:57 -0400
You must sign in to add an answer. If you do not have an account, you can register here