I know that when we create an index then statistics are automatically created. My question is: Is it the only case when statistics are created? I remember that once I found on the internet that we have column statistics along with index statistics. Could you please enlighten me regarding this topic? When I execute the below script I get the following result:
use movies go EXEC sp_helpstats @objname = '[dbo].[actors]', @results = 'ALL';
This object does not have any statistics or indexes.