aspose file tools
The moose likes JDBC and Relational Databases and the fly likes MySQL - Index Type Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of OCA Java SE 8 Programmer I Study Guide 1Z0-808 this week in the OCAJP forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "MySQL - Index Type" Watch "MySQL - Index Type" New topic
Author

MySQL - Index Type

Scott Selikoff
author
Saloon Keeper

Joined: Oct 23, 2005
Posts: 3736
    
  10

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?


[OCA 8 Book] [Blog]
Scott Selikoff
author
Saloon Keeper

Joined: Oct 23, 2005
Posts: 3736
    
  10

Nevermind, "SHOW INDEX FROM [table]" gave me the information I needed.
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: MySQL - Index Type