Enabling caching in Data Virtualization

Improve query performance with Data Virtualization by caching result sets and virtualizing remote data.

Improving query performance with Data Virtualization

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 run queries that join these tables.

Optimizing performance with caches

To avoid time-consuming query executions, Data Virtualization Administrators can create a cache to store the result sets of your queries. This improves performance by reducing the need for repeat queries. The query optimizer automatically chooses a query plan that uses caches when it is the most optimal approach.

For more information, see Managing data caches and queries in Data Virtualization.