• Good article!

    One thing I'm not sure of is where you would use CREATE STATISTICS.

    I know indices maintain their own statistics but if you do a query using an ORDER BY, WHERE, GROUP BY, HAVING etc on a non-indexed column SQL Server creates a _wa_sys statistic.

    Is there a performance overhead in maintaining these statistics as there is with indices?