[rt-users] weird Slow SelectOwner query

[Alexander Boström]

tor 2006-06-01 klockan 16:55 +0400 skrev Ruslan Zakirov:
> I've investigated more on this problem and found out that this problem
> of mysql as couldn't optimize well some queries when it's possible, I
> know how to hack a workaround and help RDBMs optimize it, but later...
> -EHAVENOTIME

The following seems to help MySQL optimize the query better:

alter table ACL add key ACLKTH1 using BTREE (PrincipalType, RightName);

/Alexander