[rt-users] DisGrouMem index

Raed El-Hames rfh at vialtus.com
Wed Apr 14 10:31:17 EDT 2010

Thanks to everyone reply ..
I should have done a bit more research first , I had another index 
combining (GroupId,MemberId) that must have been added by me/some one in 
my organisation,
and I wrongly assumed that RT created both indexes making the DisGrouMem 
(GroupId,MemberId,Disabled) useless.
Been using RT for many years , lost track of what was done when and by 
whom ..

Once again thanks for all the replies


Ian Pellew wrote:
> 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

More information about the rt-users mailing list