Q&A BY TAG 'Generate stats'

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

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

Error when trying Gather the Statistics for a Base View (JDBC Oracle database)
answered 13-06-2017 06:11:21 -0400

When I try to gather the statistics for a Base View (based on a Oracle 12g JDBC database), I am getting the error: "Error gathering the statistics of the view: Error loading jdbc data source 'ds_edsm_orcl'." and I get the following for the same Base V...

Answers: 1

Denodo 6.0 JDBC oracle database connection Generate stats

Export Statistic of a view.
answered 10-01-2017 13:08:53 -0500

Is there any way to Export Just the statistic of a view . I know that we can export the view and select the option to include statistic but, i just want to know if we have gathered statistic in Test Environment can we just take those statistic in one ...

Answers: 5

Generate stats

Generating Statistic for views through scheduler
answered 10-01-2017 13:08:03 -0500

Hi, I want to copy the views from Test environment to Production , thought of using DESC VQL VIEWSTATSUMMARY viewname on test and used its output in prod. I want to perform this for all views through scheduler. My Test and Production are same. Can you ...

Answers: 2

scheduler Generate stats

Do we need to generate the statistics for Interface views
answered 07-12-2016 05:41:51 -0500

Generating statistics for base view is enough or generating statistic for interface views will also improve performance

Answers: 1

view VDP query optimisation interface Generate stats

Generate Stats SP
answered 10-05-2016 14:48:24 -0400

Hi there, I am using both the "generate_stats" and the "generate_stats_for_fields" within the VQL shell. My datasource is not givng us back the details in the default time alloted to the SP (Which I believe is 80 seconds). I tried adding the context (...

Answers: 1

Generate stats

CALL GENERATE_STATS for multiple views ?
answered 10-02-2015 06:20:53 -0500

Hi, can someone help me how to generate stats for multiple views from scheduler ? Below command works fine for one view, but I would like to generate stats for multiple views . Please let me know if we have any other options to generate stats and sch...

Answers: 1

Generate stats