Re: need help on optimizing my query

[Apesu]

+-------+------------+-----------------+--------------+-----------------+-----------+-------------+----------+--------+------+------------+---------+
| Table | Non_unique | Key_name        | Seq_in_index | Column_name     | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment |
+-------+------------+-----------------+--------------+-----------------+-----------+-------------+----------+--------+------+------------+---------+
| map   |          1 | imsi            |            1 | imsi            | A         |        NULL |     NULL | NULL   | YES  | BTREE      |         |
| map   |          1 | seizure_time    |            1 | seizure_time    | A         |        NULL |     NULL | NULL   | YES  | BTREE      |         |
| map   |          1 | msisdn          |            1 | msisdn          | A         |        NULL |     NULL | NULL   | YES  | BTREE      |         |
| map   |          1 | origGlobalTitle |            1 | origGlobalTitle | A         |        NULL |     NULL | NULL   | YES  | BTREE      |         |
| map   |          1 | termGlobalTitle |            1 | termGlobalTitle | A         |        NULL |     NULL | NULL   | YES  | BTREE      |         |
+-------+------------+-----------------+--------------+-----------------+-----------+-------------+----------+--------+------+------------+---------+
5 rows in set (0.00 sec)