You can translate the question and the replies:

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 schedule to refresh stats automatically. CALL GENERATE_STATS('location');
user
09-02-2015 18:11:21 -0500
code

1 Answer

Hi, Generating statistics for multiple views from Scheduler is pretty simple. To do that please, follow the steps described below: 1. Create a new VDP Scheduler job. 2. After naming the job, go to Extraction Section and select the desired VDP data source. 3. The Parameterized query should look like : CALL GENERATE_STATS('@viewname'). 4. @viewname is a variable, that needs to be configured using the new panel that appears underneath the Parameterized query panel. 5. In the Non Parameterized Query panel you can choose the data source to set values to the @viewname variable. You can choose a list, where you can specify all your views separated by commas. You can choose to get the view names from VDP if you have a view in VDP the the names of the views. You can use the stored procedure CATALOG_VIEWS() as follows: select resultname as viewname from CATALOG_VIEWS() 6. In the mapping section, select the query parameter viewname and the source parameter from the Non Parameterized Query panel. With this job configuration, Scheduler will execute the statistics for all your views. Hope this helps!
Denodo Team
10-02-2015 06:20:53 -0500
code
You must sign in to add an answer. If you do not have an account, you can register here