I am working in the environment that we have to do indexes check in. When I run some script in a database it gives me some indexes are exactly duplicated and some with partially duplicated. When I went and see in the TFS, some of those Indexes are not checked in. Directly they created in the database before the patch. What will be the damages of duplicate indexes? If I want remove partial duplicate indexes, how can I know which Indexes is better than other indexes?