This post is more than 5 years old
643 Posts
0
826
Oracle Temporary Tables
I created some small temporary tables to improve a big query performance, I am wondering if there will be any impact to the database?
This post is more than 5 years old
643 Posts
0
826
I created some small temporary tables to improve a big query performance, I am wondering if there will be any impact to the database?
Top
Neil_Li2
11 Posts
0
June 12th, 2012 03:00
In Oracle temp table = global temp table.
global temporary table generate some amount of redo, less than normal table. So if you are generating a great number of rows, and the results are not needed when the current session ends, you may want to create the table as a temporary table instead
zhaos2
643 Posts
0
June 12th, 2012 00:00
Thanks for your help, Charlie, they are not global temporary tables.
Anonymous
5 Practitioner
5 Practitioner
•
274.2K Posts
0
June 12th, 2012 00:00
Are these tables Global Temporary Tables, or just normal tables?
Anonymous
5 Practitioner
5 Practitioner
•
274.2K Posts
1
June 12th, 2012 00:00
There should not be any problem by creating some temp tables, however, you can make them as global temp tables to avoid dynamic SQL and allowing more than one session to run the procedure at once.