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 ?