Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Suggestion

RE: Suggestion

From: Looney, Jason <Jason.Looney_at_echostar.com>
Date: Tue, 2 Nov 2004 16:13:44 -0700
Message-ID: <B8C9CF34B3F7164282C8610C93BB94AF04C63528@riv-exchb1.echostar.com>


Sounds like a good candidate for Global Temporary Table.

Jason.

-----Original Message-----

From: hamid alavi [mailto:alavihamid_at_gmail.com] Sent: Tuesday, November 02, 2004 3:25 PM To: oracle-l_at_freelists.org
Subject: Suggestion

Dear List,

I have a table which insert data by 300 users then they browse the data then delete it(all thru a store procedure), in my store procedure I pass a sequence number then insert this sequence number plus some other data into this table then browse the result and finaly delete these data with the same value of sequence, in this way many users can insert & delete data, MY question is IF I don't delete the data and only insert it and in a time period as a window(mid night) truncate the table would be faster or not? Any idea?
Thanks,
--

http://www.freelists.org/webpage/oracle-l
--

http://www.freelists.org/webpage/oracle-l Received on Tue Nov 02 2004 - 17:09:44 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US