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 _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
