Under the Options window, the SQL Scanner and Optimization tabs contain several settings that control the use of temp tables in the SQL Scanner and SQL Optimizer modules.
SQL Scanner Tab - Options Button
Override previous Scanner Temp Table
Optimization Tab - Optimization Button
Apply selected SQL Options to temp table SQL