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. INDEXDavid T. Ashley19 Jun
  • Re: KEY vs. INDEXBaron Schwartz19 Jun