As a performance-booster the TARGIT InMemory Database Server creates temp tables when it feels sub-query-returns might be reused (e.g. for nested JOINs or where dynamic dates are used).
The creation of these temp-files can be switched off by the inclusion of the NOCACHE keyword. See also: CACHE.

  • No labels