Hi!
We are trying to duplicate the functionality of one of our soon-to-be-out-of-business vendors, and I just got the DDL today.

It consists of ONE table with 110 columns. It has 10 indexes, each on ONE column only.

My question is: What is the benefit (if any) of having 10 one-column indexes? Would it me more efficient (for updates) to have more than one column in each index? Although not all 10 in one.

I'm interested to hear your opinions.

Thanks!
Jodie