Hi,
I'm having problem tuning a query with 4 tables, one of which is a global temp. table.
I created a normal table with the same structure and data as the temp table and used it in the query instead of the temp table and the query returned the data instantly.
In the explain plan, if I use the global temp table, it shows 16k rows read from it, while if I replace it with the regular table, it shows just 64 rows read from the table, although the number of rows is exactly the same in both the tables.
Is there anything in the instance that I can look at to see why it is taking so much more time with the use of the temp table?
Thanks!
I'm having problem tuning a query with 4 tables, one of which is a global temp. table.
I created a normal table with the same structure and data as the temp table and used it in the query instead of the temp table and the query returned the data instantly.
In the explain plan, if I use the global temp table, it shows 16k rows read from it, while if I replace it with the regular table, it shows just 64 rows read from the table, although the number of rows is exactly the same in both the tables.
Is there anything in the instance that I can look at to see why it is taking so much more time with the use of the temp table?
Thanks!
