Latest Activity

Collecting Field wise stats without using CSV

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 ?

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

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

Gather Statistics Generate stats

Error when trying Gather the Statistics for a Base View (JDBC Oracle database)

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

Denodo 6.0 JDBC oracle database connection Generate stats

Export Statistic of a view.

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

Generate stats

Generating Statistic for views through scheduler

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

scheduler Generate stats

Do we need to generate the statistics for Interface views

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

view VDP query optimisation interface Generate stats

Generate Stats SP

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

Generate stats

CALL GENERATE_STATS for multiple views ?

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

Generate stats