MySQL Forums
Forum List  »  NDB clusters

Re: more complex queries on clusters
Posted by: Jörg Nowak
Date: September 14, 2005 01:10AM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
2400
September 13, 2005 02:26AM
1646
September 13, 2005 09:07AM
1542
September 13, 2005 10:52PM
1658
September 14, 2005 03:51AM
1501
September 19, 2005 06:31AM
1455
September 19, 2005 07:05AM
1435
September 19, 2005 07:17AM
1584
September 19, 2005 07:37AM
1516
September 19, 2005 07:51AM
1431
September 19, 2005 08:15AM
1537
September 19, 2005 08:19AM
1532
September 19, 2005 08:22AM
1349
September 19, 2005 08:34AM
1538
September 19, 2005 08:46AM
Re: more complex queries on clusters
1457
September 14, 2005 01:10AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.