[Rt-devel] Slowest query in our setup

[Ruslan U. Zakirov]

Jesse Vincent wrote:
> 
> 
> On Sun, Aug 01, 2004 at 02:41:37AM +0400, Ruslan U. Zakirov wrote:
> 
>>	Hello.
>>SELECT + EXPLAIN attached.
>>
>>Fix to issue with Queue-Roles(Queue CC/AdminCc rights was not inherited 
>>by tickets) broke optimisation ability.
> 
> 
> Can you list off the indices you have on groups?
> 
show keys from Groups;
+------------+----------+--------------+-------------+-------------+
| Non_unique | Key_name | Seq_in_index | Column_name | Cardinality |
+------------+----------+--------------+-------------+-------------+
|          0 | PRIMARY  |            1 | id          |      211821 |
|          1 | Groups1  |            1 | Domain      |          17 |
|          1 | Groups1  |            2 | Instance    |      105910 |
|          1 | Groups1  |            3 | Type        |      211821 |
|          1 | Groups1  |            4 | id          |      211821 |
|          1 | Groups2  |            1 | Type        |          17 |
|          1 | Groups2  |            2 | Instance    |      211821 |
|          1 | Groups2  |            3 | Domain      |      211821 |
|          1 | Groups4  |            1 | Type        |          69 |
+------------+----------+--------------+-------------+-------------+