Latest Activity
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
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...
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...
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 ...
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 ...
Generating statistics for base view is enough or generating statistic for interface views will also improve performance
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 (...
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...