I just noticed that our database's largest table has two indexes that appear to do nearly the same thing:
Index Name Field Name Primary Unique IgnoreNulls
PrimaryKey KeyUID Yes Yes No
IndexKeyUID KeyUID No No No
I am tempted to delete IndexKeyUID. Is that a bad idea?
In fact, I am not sure I know if the index name really matters. Could it be called "George" and still accomplish the same thing?