You can translate the question and the replies:

About VCS Statistics of views

Hi team Currently all of DV views are VCS by gitlab. I have a base view created, which is build on Oracle database. Now the views is under VSC bygitlab also, but it has no stastics gathering. So I gathered its statstics, and I also make the vql shown with checking "include stastics", and I save this view, but I found the VCS status of this base view as no changed, seems the VCS cannot get the change before and after stastics gathering. Can you please help us know how to VCS the views stastics, when we migrate, we also want to migrate the view's stastics. Thank you!
view statistics VCS gitlab
user
05-08-2020 04:28:01 -0400
code

1 Answer

Hi, You can version control the elements in the database such as data sources, views, and web services, and also custom i18n maps and jar extensions that are particular to the database. But you cannot version the elements that are global to the server like users, roles, database settings, etc. The statistics of a view are also not included in version control because they are environment-dependent. Please refer to the [“Gathering the Statistics of the Views”](https://community.denodo.com/docs/html/browse/7.0/vdp/administration/optimizing_queries/cost-based_optimization/gathering_the_statistics_of_views#how-the-gathering-statistics-process-works) section of Virtual DataPort Administration Guide for more information on how to gather and store statistics of the view. Hope this helps!
Denodo Team
05-08-2020 17:35:10 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here