Win a copy of Programmer's Guide to Java SE 8 Oracle Certified Associate (OCA) this week in the OCAJP forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

MySQL - Index Type

 
Scott Selikoff
author
Saloon Keeper
Posts: 4020
18
Eclipse IDE Flex Google Web Toolkit
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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?
 
Scott Selikoff
author
Saloon Keeper
Posts: 4020
18
Eclipse IDE Flex Google Web Toolkit
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Nevermind, "SHOW INDEX FROM [table]" gave me the information I needed.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic