I agree with the remark below. If you modify indexes, other queries may now perform poorly. It is just a tip of the iceberg.

In theory, you have a primary key there for a reason. If the question had given more information as to the purpose of the primary key, then a better decision to drop the index on the primary key could have been made. As it stands, the question is poorly worded.

[/quote]