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:
Please sign in to leave a comment.