title: Does the order of index_together matter in a Django model?
body: <p>When defining a model with an index_together Meta property, does the order of the columns matter?</p>
  
  <p>In other words, is there a difference between</p>
  
  <pre><code>Class myModel(models.Model):
      name = models.CharField(max_length=100)
      address = models.CharField(max_length=100)
      favorite_color = models.CharField(max_length=20)
  
      class Meta:
          index_together = ('name', 'address', 'favorite_color')
  </code></pre>
  
  <p>vs</p>
  
  <pre><code>Class myModel(models.Model):
      name = models.CharField(max_length=100)
      address = models.CharField(max_length=100)
      favorite_color = models.CharField(max_length=20)
  
      class Meta:
          index_together = ('favorite_color', 'name', 'address')
  </code></pre>
  
  <p>I only ask because I've noticed when looking at the structure of a table, each column in the key has an "index in key" property. Does MySQL/PostgreSQL expect the columns to be queried in that order?</p>
  
  <p>Just as an aside, is there a great deal of difference between indexing the columns together vs separately?</p>