I have a query which aggregates data from a global temporary table. The table will be filled right before the aggregation. My goal is a reliable explain plan for that query.
Is there a way in OracleDBMS to simulate a fill level of the temporary table, witout the necessity to insert anything?
INSERT INTO gtt VALUES(..) SELECT * FROM gtt
EXPLAIN PLAN FOR SELECT * FROM gtt /* with hint for maybe 10k records */
Motivation: The goal is to find out whether the statement falls below the threshold values for costs and CPU. We want to find out, what kind or what amount of temporary data breaks our tuning concept.