Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Dropping Tables - Slow Performance
In article <36b314af_at_news3.ibm.net>, Nicolas Bronke <NBronke_at_Trinity.de>
writes
>Try to truncate the data of the tables first. Truncate remove data without
>using rollbacks.
I'd be tempted to agree, if only because it's the simple solution. 9/10 people claiming to have a performance problem dropping are just forgetting to truncate first. I'm surprised Oracle haven't 'optimized' that statement (DROP TABLE FRED)!
--
Karl Royle
Received on Sun Jan 31 1999 - 14:51:06 CST