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