You can translate the question and the replies:

Find Cache Index Tables

Hi, Can you please advise how Cache Index Tables can be found related to a Cached View. Procedure GET_CACHE_TABLE displays information about Cache Data Tables only. Thanks. User
user
16-12-2020 00:55:04 -0500

1 Answer

Hi, [GET_CACHE_TABLE](https://community.denodo.com/docs/html/browse/latest/vdp/vql/stored_procedures/predefined_stored_procedures/get_cache_table) stored procedure returns the name of the table in the cache database that holds the **cached data for a specific view** (i.e., data table for each cached view (C...)). It also returns additional information about the cache configuration of the view but not the *metadata tables* available for Cache management. In case you need to access these *metadata tables*, you could make [introspection](https://community.denodo.com/docs/html/browse/latest/vdp/administration/creating_data_sources_and_base_views/jdbc_sources/jdbc_sources#creating-base-views-from-a-jdbc-data-source) in the cache data source from Virtual DataPort Administration tool. The following table names should exist: VDB_CACHE_NAMES, VDB_CACHE_QUERYPATTERN, VDB_CACHE_SEQUENCES, VDB_CACHE_VIEWNAME. Hope this helps!
Denodo Team
16-12-2020 07:17:32 -0500
You must sign in to add an answer. If you do not have an account, you can register here