Browse Community
Language
Help
Sign In
Posts
Users
Search
zhaos2
updated
14 years ago
Solved!
2 Intern
•
643 Posts
0
956
June 11th, 2012 23:00
I created some small temporary tables to improve a big query performance, I am wondering if there will be any impact to the database?
Responses (2)
Solutions (0)
Neil_Li2
11 Posts
412
Posted 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
Posted June 12th, 2012 00:00
Thanks for your help, Charlie, they are not global temporary tables.
Self Repair, Upgrade & Maintain
Diagnostics and Tools
Drivers & Downloads
Solve
XPS Desktops
21
5
Dell Pro Laptop Computers
6
2
Customer Care
13
Dell OpenManage Enterprise
27
3
Inspiron
81
4
View More
Neil_Li2
11 Posts
412
0
Posted 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