Re: more complex queries on clusters
As Jay has said, an EXPLAIN is a useful thing to start with.
From there we can work out what indexes are being used and how many rows have to cross over the wire.
What fields in these tables are indexed?
Stewart Smith, Software Engineer - MySQL Cluster
MySQL AB, www.mysql.com
Jumpstart your cluster:
http://www.mysql.com/consulting/packaged/cluster.html
Subject
Views
Written By
Posted
2616
September 13, 2005 02:26AM
1788
September 13, 2005 09:07AM
Re: more complex queries on clusters
1664
September 13, 2005 10:52PM
1787
September 14, 2005 03:51AM
1626
September 19, 2005 06:31AM
1574
September 19, 2005 07:05AM
1560
September 19, 2005 07:17AM
1722
September 19, 2005 07:37AM
1629
September 19, 2005 07:51AM
1566
September 19, 2005 08:15AM
1656
September 19, 2005 08:19AM
1649
September 19, 2005 08:22AM
1474
September 19, 2005 08:34AM
1645
September 19, 2005 08:46AM
1579
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.