Is there a way to run a sql statement that populates a temp table before the optimizers runs against a sql statement that queries said temp table...or alternately a way to make the optimizer run an existing instance where the temp table is already populated?
Based on what you've described,
Can you get by with a CTE (common table expression)?
e.g. using a WITH clause ...
Can you populate the temp table up front, and then run your query optimization right after?
Otherwise, let the community know added details of what you're trying to accomplish.