if, however, you drop the index, you are eliminating all the index's automatic action in preventing duplicate values!
I believe that the note on FKs actually states that if you have a well-defined application, you do not need exclusive table locks.