Clustered-Indexes

Tag: clustered-indexes

Does a Clustered Index Give a Default Ordering?

By Kendra Little on February 2, 2018

Category: query-performance , sql-server

I recently got a great question: if I order by a column where all rows in that column have the same value, will SQL Server then order the results by the clustered index key?

Copyright (c) 2025, Catalyze SQL, LLC; all rights reserved. Opinions expressed on this site are solely those of Kendra Little of Catalyze SQL, LLC. Content policy: Short excerpts of blog posts (3 sentences) may be republished, but longer excerpts and artwork cannot be shared without explicit permission.