• It looks like it's using the clustered index almost exclusively for all data access. I don't know if that's by design or if you thought it would use the other indexes and do lookups. Do the other indexes have included columns. Are your queries returning most of the columns from the table.

    Tom