Speed Oracle SQL with Temporary Tables (GTT)

The effective use of temporary tables while doing huge batch process can boost performance. The concept is to store intermediate data while performing huge processing in temporary tables. Temporary table store data in-memory that results in better and stable SQL plan for complex summarization activities.

#GTT #SQL Performance #Oracle

Read More
Comment

Oracle Temporary tables - Features and Effective Use

Oracle Database temporary tables hold data that exists only for the duration of a transaction or session. Data in a temporary table is private to the session, which means that each session can only see and modify its own data.Temporary tables are useful in applications where a result set must be buffered.

Read More
Comment