Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Global Temp table Vs Regular table

user621430Jan 24 2013 — edited Jan 24 2013
Hi,

I need a temp table to store few IDs (which I select from a complex query). I would be deleting the data from the temp table at the end of the session.

From a performance perspective, I was wondering if I should be using a GLOBAL temporary table or just a regular table in which I will manually delete rows at the end.

The tkprof showed using the global temp table expensive. If yes, I just want to confirm it and know why it is the case.

Thanks!
Anand
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 21 2013
Added on Jan 24 2013
11 comments
1,164 views