Question about duplicate indexes according to a sql assessment by microsoft

SQL Server Administration
1

Hi ,
I have a table with 10 columns on which there are several indexes.
There are two indexes on the table that are , according a sql assessment, duplicate.
I want to be sure if I can delete one of them.
Frist Index is an index on one field : operatoroid
The second index is an index on two fields : operatoroid , zoneoid

Can i delete the first index without performance loss ?

Thx,
Patrick

2

Generally yes.

3

Like Scott said, "Generally Yes" but not if it's a UNIQUE index. You need to check for that..

1 Like