> TRUNCATE TABLE URL_PAGES drop storage;
Oracle is clever enough and does this optimisation by default with tuncate.
Unfortunalte this solution is temporary and you need to schedule the
job that truncates the table every now and again. Otherwise,
performance will degrade again.
If the job is scheduled often enough it could be nice to include, on
the contrary, KEEP STORAGE clause.
--
Best regards,
Alex Gorbachev
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Mar 15 2005 - 18:41:56 CST
