Unanswered: Create Temporary Global Table vs. Create Table
I was wondering if any one could clarify the advantages/disadvantages of using Temporaray Global Tables vs. a regular physical table? I use temp tables to hold and manipulate data before returning it to a 3rd party reporting application (ie, Crystal, Business Objects) with a ref cursor. It makes more sense to me to use the temporary global tables because you do not have to execute a 'delete from temp_table_a' when the procedure is done - it just wipes the table automatically when the session is ended. My question revolves around is it really more efficient to do it this way. Is one more process intensive than the other? Or does it not really matter? BTW- I am using Oracle 9i on a Solaris platform.