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
16-12-2020 00:55:04 -0500

1 Answer

Hi, [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]( 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