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
2812
September 13, 2005 02:26AM
1860
September 13, 2005 09:07AM
Re: more complex queries on clusters
1728
September 13, 2005 10:52PM
1853
September 14, 2005 03:51AM
1681
September 19, 2005 06:31AM
1632
September 19, 2005 07:05AM
1622
September 19, 2005 07:17AM
1804
September 19, 2005 07:37AM
1698
September 19, 2005 07:51AM
1624
September 19, 2005 08:15AM
1743
September 19, 2005 08:19AM
1706
September 19, 2005 08:22AM
1529
September 19, 2005 08:34AM
1729
September 19, 2005 08:46AM
1645
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.