[teiid-issues] [JBoss JIRA] (TEIID-2981) Add an OData query parameter that caches the resultset

Add an OData query parameter that caches the resultset ------------------------------------------------------ Key: TEIID-2981 URL: https://issues.jboss.org/browse/TEIID-2981 Project: Teiid Issue Type: Feature Request Components: OData Affects Versions: 8.7 Reporter: John Muller Assignee: Steven Hawkins Priority: Minor Labels: Caching, OData, Fix For: 8.8 The Teiid caching guide indicates that the /*+ cache */ SQL hint is neccessary in order to cache results [1] . We would like two features added to the OData support: (1) to have a query parameter that basically injects the hint into the SQL statement run against the VDB and (2) a configuration setting that turns on OData resultset caching for all result sets smaller than some size (perhaps 256 as the default)