title: Different order of columns in create index
body: <p>I Want To Create Index In SQL Server in Column1 and Column2 What is the difference of below query in Performance of execute query on MyTable:</p>
  
  <pre><code>CREATE NONCLUSTERED INDEX [IX_1] ON [dbo].[MyTable] 
  (
      [Column1] ASC,
      [Column2] ASC
  ) ON [PRIMARY]
  
  
  CREATE NONCLUSTERED INDEX [IX_2] ON [dbo].[MyTable] 
  (
      [Column2] ASC,
      [Column1] ASC
  )ON [PRIMARY]
  </code></pre>