By default, 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 nocache=true in the targitdb.ini file.
Including the CACHE keyword in a select statement, overrides this statement by using cache. See also:
Nocache.
Comments
Please sign in to leave a comment.