You can translate the question and the replies:

How to get list of views with statistics enabled

How can I get a list of views where statistics has been enabled for a given database?

1 Answer

Hi, You can use the list command in the VQL shell. The LIST VIEWSTATSUMMARIES lists the views that have statistics enabled that can be used by the Cost-based optimization. You can refer to the following document for more information on statistics https://community.denodo.com/docs/html/browse/6.0/vdp/vql/defining_the_statistics_of_a_view/defining_the_statistics_of_a_view#defining-the-statistics-of-a-view If you want to have more details on the list command here is the document to follow: https://community.denodo.com/docs/html/browse/6.0/vdp/vql/listing_elements_in_the_catalog/listing_elements_in_the_catalog Hope this helps!
Denodo Team
13-06-2019 20:19:58 -0400
You must sign in to add an answer. If you do not have an account, you can register here