Hi everyone -

I've read that unique indexes perform better than nonunique indexes.

Now, in an app where I do not have the source code, I have found some indexes that are classified as 'nonunique', but every row in the index is indeed unique.

Can I expect better performance out of this index if I drop it and recreate it as unique? Or does it perform as well as a unique index now because it actually is unique even though it is not defined in the data dictionary as such.

The index is quite large so I don't want to just 'do it and see'.

thanks for your help!

-John