Caveat, In reference to the ongoing discussion of QUALCOLS and STATICDB, DROP indexname is not available if you are running with STATICDB ON.
Jan -----Original Message----- From: Lawrence Lustig <[email protected]> To: [email protected] (RBASE-L Mailing List) Date: Wed, 4 Nov 2009 12:17:17 -0800 (PST) Subject: [RBASE-L] - Re: space in zipcode << Thanks Bob and Buddy. I did both of those you recommended and it sped it up but still takes alot of time. It is a big(727,000 rows) temporary table. >> If that field is indexed, or participates in a multi-column index, drop the index before you issue the update, then recreate it afterwards. -- Larry
