Match index types to the type of comparisons you perform.
When you create an index, most storage engines choose the index implementation
they Match index types to the type of comparisons you perform. When you
create an index, most storage engines choose the index implementation they will
use. For example, InnoDB always uses B-tree indexes. MySQL also uses B-tree indexes,
except that it uses R-tree indexes for spatial data types. However, the MEMORY
storage engine supports hash indexes and B-tree indexes, and allows you to select
which one you want. To choose an index type, consider what kind of comparison
operations you plan to perform on the indexed column:
Ads by Google
Design details of Audiogalaxy.com’s high performance MySQL search engine | Spiteful.com
more fromwww.spiteful.com
2Expand
How FriendFeed uses MySQL to store schema-less data - Bret Taylor's blog
more frombret.appspot.com
Using DTrace to observe the SQL statements on a live running MySQL database : Angelo's Soapbox
test
more fromblogs.sun.com
Joyeur: Quick wins with MySQL
more fromjoyeur.com
1Expand
Kitchen Soap » Blog Archive » Slides from ‘Capacity Planning for LAMP’ talk at MySQL Conf 2007
more fromwww.kitchensoap.com
Notation: * = Private bookmark and comment|… = Clipping [?] | … = Public highlight [?]
Joel Liu's Related Tags
See More Top Contributors
Related Groups on Diigo
Related Lists on Diigo
-
PHP+Apache+MySQL+PHPCMS学习计划
PHP+Apache+MySQL+PHPCMS学习计划
Items: 37 | Visits: 147
Created by: 刘 正刚
-
MyISAM vs InnoDB
Items: 5 | Visits: 113
Created by: Ken Wei
-
Matrix Software
AJ Matrix is the latest and...
Items: 0 | Visits: 107
Created by: swasaaron