Automatic Passthrough for Hybrid Cache Groups
Set the TT_DynamicPassthrough
optimizer hint to notify
TimesTen to pass through qualified SELECT
statements to the Oracle database
for cache groups created without a WHERE clause.
For cache groups without a WHERE
clause, you can set the
TT_DynamicPassthrough
(N
) optimizer hint
that notifies TimesTen to pass through any SELECT
statement to the
Oracle database if it results in a dynamic load of a cache instance with >=
N
number of rows. See Automatic Passthrough of Dynamic Load to the Oracle Database.