Win a copy of Murach's Python Programming this week in the Jython/Python forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

MySQL - Index Type  RSS feed

 
Scott Selikoff
author
Bartender
Posts: 4081
21
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
Bartender
Posts: 4081
21
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
Boost this thread!