Re: more complex queries on clusters

[Jörg Nowak]

Thanks, I did the same statement wtih explain in front of the statement and I got the following output:

explain select i.mIMSI, b.BasicServiceCodeId from IMSI i, MSISDN m, BasicServiceCode b where i.mIMSI=m.associatedIMSI and m.associatedBasicServices=b.basicServiceCodeId and i.mIMSI=200001311;


+----+-------------+-------+------+-------------------------+-------------------------+---------+-------------------------------+------+-------------+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
+----+-------------+-------+------+-------------------------+-------------------------+---------+-------------------------------+------+-------------+
| 1 | SIMPLE | b | ALL | PRIMARY | NULL | NULL | NULL | 1000 | |
| 1 | SIMPLE | m | ref | associatedBasicServices | associatedBasicServices | 5 | ISS_HLR2.b.basicServiceCodeId | 1 | Using where |
| 1 | SIMPLE | i | ALL | NULL | NULL | NULL | NULL | 1000 | Using where |
+----+-------------+-------+------+-------------------------+-------------------------+---------+-------------------------------+------+-------------+


Does it mean the problem is a full table scan over the table "BasicServiceCode" or is there another problem ? My tables have only 1000 rows at the moment.

Joerg Nowak