title: Non-clustered index and clustered index on the same column
body: <p>I came across <a href="https://stackoverflow.com/questions/42015/non-clustered-index-on-a-clustered-index-column-improves-performance">this</a> post in Stackoverflow. The first answer mentions something like <strong>A clustered index has all the data for the table while a non clustered index only has the column + the location of the clustered index or the row if it is on a heap (a table without a clustered index).</strong> How can a non-clustered index have the location of the clustered index? It only contains the column values sorted as nodes in a B-treee with each node pinting to the row where the column has that node-value, right?</p>