If on Oracle, truncating the tables is the best way, as it resets the high water marks for storage on the table. Imagine that a table scan on a table with 10 rows could have the same number of physical reads as the same table with 1m rows if the high water marks are the same. If you need to retain some of the data, use this as a guide:
create table T100_tmp as select * from T100 where ... / truncate table T100 / insert into table T00 select * from T100_tmp / drop table T100_tmp / rinse and repeat for the B#, B#C# and H# tables, using the resulting data in the T# table as the guide for which rows to retain from each. This will allow you retain the data you want while resetting the high water marks. Axton Grams On 9/18/07, Roger Justice <[EMAIL PROTECTED]> wrote: > ** Truncate the table is the simplest way. > > > > -----Original Message----- > From: Patel, Kamlesh <[EMAIL PROTECTED]> > To: [email protected] > Sent: Tue, 18 Sep 2007 3:46 pm > Subject: delete mass amount of records from ARS 5.1.2 > > > ** > > All, > I am going through an upgrade plan to 7.x. Before I begin my upgrade I > would like to remove lots of data records form our remedy forms. I have a > pretty good idea about remedy 5.1.2 patch 1375 data structure. I would like > to find out if there is alternative safe and fast way to remove up to > 1,000,000 records from couple of remedy forms. Most other forms are > relatively small but I would like to employ a fast delete operation to > minimize the outage period. > > Thank You > > Kamlesh Patel > __20060125_______________________This posting was > submitted with HTML in it___ > ________________________________ > Email and AIM finally together. You've gotta check out free AOL Mail! > > __20060125_______________________This posting was > submitted with HTML in it___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
