Sql Server, Query Optimization.
automatically creates statistics for single columns in a table when an index is created on that column. However, if you want to create statistics explicitly without creating an index, you can use the following syntax — CREATE STATISTICS <stat_name> ON <table_name> (<column_name>); CREATE STATISTICS