Home Forums Article Discussions Article Discussions by Author Discuss content posted by Francis Rodrigues ROW_NUMBER(): An Efficient Alternative to Subqueries RE: ROW_NUMBER(): An Efficient Alternative to Subqueries

  • February 7, 2010 at 4:05 am

    #1115167

    Paul,

    The reference you mentioned explicitly states that when a secondary index is not declared UNIQUE, it contains the values of the clustered key in the key-level pages:

    Now you should see something different. The first index, nonunique, still has all three columns in the upper level page: the nonclustered key SalesOrderDetailID, and the two columns of the clustered key: SalesOrderID and the uniqueifier.