title: Order by on indexed column
body: <p>I am not clear on the following:<br>
  Assume I have a table <code>A</code> and I have created an index on column <code>X</code>.<br>
  If I do select based on the column that result will be sorted, right?<br>
  But if for some reason I did a select followed by an <code>ORDER BY X</code> (e.g. I was unaware that the column was indexed) will the SQL server do the sort performing sequential access or will it go and use the index?</p>