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
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
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
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
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
Generating statistics for base view is enough or generating statistic for interface views will also improve performance
Answers:
1
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
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