SQL Performance (MOSC)

MOSC Banner

Global temporary table slowness issue

edited Jun 13, 2019 5:00AM in SQL Performance (MOSC) 17 commentsAnswered

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.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center