File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes MySQL - Index Type Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login


Win a copy of The Mikado Method this week in the Agile and other Processes forum!
JavaRanch » Java Forums » Databases » JDBC
Reply Bookmark "MySQL - Index Type" Watch "MySQL - Index Type" New topic
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.
 
I agree. Here's the link: http://ej-technologies/jprofiler - if it wasn't for jprofiler, we would need to run our stuff on 16 servers instead of 3.
 
subject: MySQL - Index Type
 
Similar Threads
setAutoCommit(false) not working
Using "FORCE INDEX" clause in HQL
Stroing a Vector in MySQL
HQL
which is better?