If you are deleting a large number of rows, or inserting, or updating, you should drop the index.<P>You're not telling us what DB you are using, but if I was doing it, and I was using Oracle, I'd drop ...