Teiid supports various kinds of caching Caching of final results of a user query, called "result set" caching. Caching contents of a virtual table, called "materialized views". This article is a practical "How To" guide for users who want to use "Materialized Views" in their use-case to improve the query performance. For more information about caching in the Teiid please consult " Caching Guide ". http://community.jboss.org/docs/DOC-16397 Thank you for using Teiid .