RE: Suggestion

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