This post is more than 5 years old
2 Intern
•
643 Posts
0
849
June 11th, 2012 23:00
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?
No Events found!
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
2 Intern
•
643 Posts
0
June 12th, 2012 00:00
Thanks for your help, Charlie, they are not global temporary tables.