Sounds like the purge should come first to me - your purge sounds like it will get rid of most of the records, so the date-based index isn't that helpful for selecting the old ones, and it will slow down the time it takes to delete each record.
-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Glorfield, Gordon Sent: Wednesday, February 16, 2011 10:08 AM To: 'U2 Users List' Subject: [U2] Purging and Indexing Good Morning, Looking for opinions and experiences here. We are trying to do some system cleanups. We found that our PO file has over 10 million records dating back some 7 years. We've decided that 2 years of PO history is plenty to keep on file. Currently there are no indices on this file. Our question is would it be quicker to do a select and delete of the older records before building an index on invoice date or would it be quicker to build the index first to use in the select for the purge? This index has been identified as being needed for some reporting. My thinking is that while the select for the purge may go quicker, if the index is in place prior to the purge then the delete process not only has to delete the selected records it also has to update the index on the fly. TIA, Gordon Gordon J Glorfield | Software Application Developer | Vertis Communications 250 W. Pratt Street, Suite 1800 | Baltimore, MD, 21201 T 410-361-8664 | M 443-280-7093 [email protected] | http://www.vertisinc.com Vertis Communications is a results-driven marketing communications company that delivers inventive advertising, direct marketing and interactive solutions to prominent brands across North America. Our deep industry knowledge and extensive range of offerings-including integrated data solutions, digital program management systems, creative services, world-class print and mail production, logistics, out-of-home and business process outsourcing-are used to deliver superior program performance that drives bottom line results for our clients. With 100 strategically positioned locations and more than 5,000 dedicated professionals, we deliver impeccable quality and fast turn-around to any market. _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users <html> <body> ________________________________ Dave Davis Team Lead, R&D P: 614-875-4910 x108 F: 614-875-4088 E: [email protected] [http://www.harriscomputer.com/images/signatures/HarrisSchools.gif] [http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif] 6110 Enterprise Parkway Grove City, OH 43123 www.harris-schoolsolutions.com This message is intended exclusively for the individual or entity to which it is addressed. This communication may contain information that is proprietary, privileged or confidential or otherwise legally exempt from disclosure. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message. </body> </html> _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
