- You create two or more partitions on a column of a table in Microsoft SQL Server 2008 R2.
- You create a clustered index on a different column of the same table.
- You run a query against the table. The query uses two or more of the partitions.
In this scenario, slow performance occurs, and a sort operation is used in the execution plan instead of the clustered index.