| List: | General Discussion | « Previous MessageNext Message » | |
| From: | David T. Ashley | Date: | June 19 2007 3:27pm |
| Subject: | KEY vs. INDEX | ||
| View as plain text | |||
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? Thanks.
| Thread | ||
|---|---|---|
| • KEY vs. INDEX | David T. Ashley | 19 Jun |
| • Re: KEY vs. INDEX | Baron Schwartz | 19 Jun |
