0

How do I configure a Virtual Procedure's result to never expire in cache? For example, how would I configure the ttl in this example so the cache never expires:

"/*+ cache(pref_mem ttl:70000) */

1 Answers1

0

add /*+ cache */ to procedure definition.

See https://docs.jboss.org/author/display/TEIID/Results+Caching

Petter Friberg
  • 21,252
  • 9
  • 60
  • 109
Ramesh Reddy
  • 554
  • 1
  • 3
  • 8