| Author |
MySQL - Index Type
|
Scott Selikoff
Saloon Keeper
Joined: Oct 23, 2005
Posts: 3652
|
|
|
I have an index on a column created in MySQL but the type does not appear to be specified. Is there a simple way to determine if this is a hash or sorted index? Does MySQL use one by default or is that a custom setting?
|
My Blog: Down Home Country Coding with Scott Selikoff
|
 |
Scott Selikoff
Saloon Keeper
Joined: Oct 23, 2005
Posts: 3652
|
|
|
Nevermind, "SHOW INDEX FROM [table]" gave me the information I needed.
|
 |
 |
|
|
subject: MySQL - Index Type
|
|
|