What about creating a new file first do a SELECT (not SSELECT) and only write to the new file the ones you want using a program (still might take a bit).
CNAME the OLD FILE when done CNAME the NEW file to the original name Then build any indexs you want on the NEW file > -----Original Message----- > From: [email protected] [mailto:u2-users- > [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 _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
