Hi,
When indexes are used and not is a part of the MySQL Server Optimiser
logic. This is done the same way
for all storage engines, what differs is the statistical parameters
supplied by the storage engine.
Rgrds Mikael
2005-06-23 kl. 10.01 skrev Jigal van Hemert:
In the past I've discovered all kinds of facts in books and
documentation
about the way MyISAM and Innodb differ in the way indexes are
constructed
and used. Many of these little facts come in handy at some point when
optimizing table structure, indexes and queries.
Can anyone explain a bit about the way NDB indexes are structured,
where
they live, when and how indexes are used in queries, etc.?
I wasn't able to find anything about this in the Cluster
documentation...
Regards, Jigal.
Mikael Ronstrom, Senior Software Architect
MySQL AB, www.mysql.com
Jumpstart your cluster:
http://www.mysql.com/consulting/packaged/cluster.html
4 messages in com.mysql.lists.clusterRe: NDB indexes; structure and usage
