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
2701
September 13, 2005 02:26AM
1811
September 13, 2005 09:07AM
Re: more complex queries on clusters
1687
September 13, 2005 10:52PM
1809
September 14, 2005 03:51AM
1642
September 19, 2005 06:31AM
1592
September 19, 2005 07:05AM
1581
September 19, 2005 07:17AM
1754
September 19, 2005 07:37AM
1658
September 19, 2005 07:51AM
1582
September 19, 2005 08:15AM
1688
September 19, 2005 08:19AM
1664
September 19, 2005 08:22AM
1494
September 19, 2005 08:34AM
1663
September 19, 2005 08:46AM
1597
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.