Update Query Optimizer Statistics
Make sure you have updated the optimizer statistics with the ttOptUpdateStats
or ttOptEstimateStats
procedure. To execute some queries, TimesTen must allocate temporary space. The amount of temporary space required is estimated from statistics about the tables used by the query. Without correct statistics, the temporary space required may be underestimated. See Using the Query Optimizer for information.