Save your data, truncate the table, then put what you want to keep back into the table.
http://www.adp-gmbh.ch/ora/concepts/space_management/high_water_mark.html On Thu, Dec 23, 2010 at 9:25 AM, Frank Caruso <[email protected]>wrote: > ** ARS 6.3 > Oracle 10 > > Deleted 3.3 million records from the SHR:ConsolidatedList form. There are > now only 15,000 records but the queries the MidTier runs for flash boards > are still slow - upwards of 20 seconds. The queries are counting groups of > records by category and group. There are no where clauses so I would not > think it is an index issue. I also made sure that statistics has been run. > The deletes were done using an ARS Perl script. > > Any thoughts on what else I might look at? > > Frank Caruso > > _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
