Listing views with cache enabled

How can I get a list of views where cache has been enabled?
user
21-07-2019 11:26:44 -0400

1 Answer

Hi, I would run the below query in the VQL shell to retrieve the list of cache enabled view names by using the built-in stored procedure GET\_VIEWS, ``` select database_name,name as view_name from get_views() where cache_status > 0 ``` For information about the above stored procedure, please refer to the section [GET\_VIEWS](https://community.denodo.com/docs/html/browse/6.0/vdp/vql/stored_procedures/predefined_stored_procedures/get_views#get-views) of the Virtual DataPort VQL Guide. Hope this helps!
Denodo Team
22-07-2019 01:43:59 -0400
You must sign in to add an answer. If you do not have an account, you can register here