title: MySQL - rearrange the order of the indexes in a table?
body: <p>is it possible to rearrange the indexes in a MySQL table ?
  I have a big table with about 20 indexes on it, but as I created them in the course of a few years, they're not logically ordered anymore.
  I would like them to have the same order as the columns in the table.
  I use Navicat, but I don't see an option to move an index up or down in the list. Is it even possible?</p>
  
  <p>UPDATE:  I just found out that in Postgresql can't even change the order of columns, let alone indexes !  And to all those people that say I have to use views, and that the columns order is not important : of course it is!  Columns and indexes should be <strong>logically</strong> ordered in the design interface. Most people use GUI's nowadays to edit their tables!</p>
  
  <p>I just can't believe something basic like this is not implemented.  It's 2011, guys !</p>