>I had a large table (over 3 million records) with multiple indices which accidentily wound up with some duplicate entries. I tried to rectify this by creating a new unique index, copying to a temp file, zapping, appending from the temp file, and eliminating the new index. This worked fine, but now all sql commands I run on the table are taking much much longer than they had! Any thoughts? Thanks!!!!!
Make sure you delete the unique index. REINDEX is not enough in some cases. You could delete each tag, sort the DBF on the master seqwnce key, and then INDEX to new tags with the same names as the tags you deleted. Assure that unique index isn't messing it up!
Imagination is more important than knowledge