Wayne Sheffield

My blog about SQL Server

Browsing Posts tagged clustered index

Understanding the relationship between statistics, indexes and constraints in SQL Server. What meaning does stats_id of 1 mean?

One thing that I have seen repeatedly is that (too) many people believe that if you have a clustered index on a table, that you can run a SELECT statement without an ORDER BY clause from that table and the results will be in the order of the clustered index key. Nope, this is absolutely […]