Enabling caching in Data Virtualization
To avoid query executions that are time-consuming, Data Virtualization administrators can create a cache to improve the performance by caching the result set of your queries.
In Data Virtualization, you can virtualize remote data sources so that data can remain remote while it is accessed through a single framework. For example, you can virtualize tables across different remote databases, and you can run queries that can join these tables.
To avoid query executions that are time-consuming, Data Virtualization Admins can create a cache to improve the performance by caching the result set of your queries. The query optimizer can choose a query plan that uses caches automatically, if it is the most optimal.
For more information, see Managing data caches and queries in Data Virtualization.