Hi,
David T. Ashley wrote:
In reading the syntax of the CREATE TABLE statement, I'm a little confused
by the two keywords KEY and INDEX.
What does one use when one wants MySQL to arrange the column so that it can
find a given record "WHERE column=whatever" in approximately O(log N) time?
This is a "key", right? MySQL uses some kind of a BTREE arrangement,
right?
Yes. Most indexes are B+ trees. KEY and INDEX are synonyms in general. There may be
places where it matters but I can't think of any. In any case it's just syntax, not
functionality.
Some storage engines offer other kinds of indexes: MyISAM offers fulltext and spatial,
MEMORY allows hash indexes.
Baron
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
