Q&A BY TAG 'Gather Statistics'

You must sign in to ask a question. If you do not have an account, you can register here

Incomplete statistics in the following nodes
answered 09-07-2020 07:15:57 -0400

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 gathe...

Answers: 1

Gather Statistics

Gaterhing stats.
answered 29-04-2020 16:58:38 -0400

So does denodo really make queries or views more efficient by gathering stats. is it sophisitcated with creating new plans and optimizations when stats are gathered.? is it a best practice to run stats on a regular basis? but if really , my mvp is ju...

Answers: 1

Gather Statistics

Collecting Field wise stats without using CSV
answered 14-01-2020 08:45:13 -0500

How can I generate statistics at a field level using the scheduler without creating the csv or the base view to pass the viewname and fieldname values ?

Answers: 3
Related to: How to update the statistics of a view automatically

Automic scheduler Gather Statistics Generate stats

Error gathering the statistics of the view: Wrong stats query resultset
answered 23-02-2018 04:46:19 -0500

When I try to gather the statistics for a Base View, I am getting the error: "Error gathering the statistics of the view: Wrong stats query resultset" I tried it going to base view > option> statistics and selected enable statistics and complet...

Answers: 1

Gather Statistics Generate stats

Export the Gathered Statistics of a Base View (or any View)
answered 14-02-2018 07:57:01 -0500

I would like to Export the Gathered Statistics of a Base View (or any View), and apply those to the same view but in another Denodo server. Please let me know how I can do so.

Answers: 1

Gather Statistics

Error gathering the statistics of the view
answered 17-11-2017 06:11:37 -0500

Hi Team, I am getting the below error while trying to gather statistics for a derived view. This derived view is created from 3 derived view and 3 db tables. Could you please help? Error messages Error gathering the statistics of the view: Error exec...

Answers: 1

Gather Statistics