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!!!!!
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement