Global temporary table slowness issue
We are facing a slowness issue in our queries where temporary tables are used. The query performance becomes slower even for small amount of data. When we recreate the temporary tables which are used in query it works fine. Could you please provide us the logic behind the temporary tables (On Commit Preserve rows and On commit Delete Rows) and the reason why recreating the temp tables improves the performance of query.