Q&A BY TAG 'Generate stats'
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
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
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
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
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
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
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
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