You can translate the question and the replies:

Is there anyway we can generate statistics for multiple table using GATHER_STATISTICS call?

I want to schedule single job to generate multiple tables statistics. Or if it is possible to give single VQL command to call GATHERSTATISTICS procedure call? For example: CALL GATHER_STATISTICS(tab1,tab2,tab3) Please suggest.
admin denodo 5.5
user
19-07-2016 12:56:06 -0400
code

1 Answer

Hey, There is a way to Call GENERATE_STATS on multiple views using a parametrized query in a Scheduler job and a table or CSV list with the views that you would like to generate statistics for. More information can be found in the document "How to update the statistics of a view automatically" in the Scheduler section of the Knowledge Base (KB). Please note, you will still need to open the view > Advanced > Statistics > check Enable statistics for each view manually before the stats will be saved. Hope that helps!
Denodo Team
20-07-2016 13:21:46 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here