>From my experience with compound indexes (Informix), the optimiser will use
>the leading component of the compound, thereafter, it would force a scan of
>the table.
The column 'disabled' is in the compound, and very likely not be the first
component and hence, a forced a scan.
Drop the index and you would deprive queries of the first component as an index.
This would be quite painfull if the first was used as a "join" component, and
probably is.
>> Is the index DisGrouMem (GroupId,MemberId,Disabled) required for 3.8
>
>I wouldn't recommend it.
.
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
