نامگذاری آمار توسط SQL Server

USE master;
GO
CREATE DATABASE StatsTest;
GO
USE StatsTest;
GO
EXEC sp_dboption 'StatsTest', 'auto create statistics', 'on';
GO
CREATE TABLE t1 (c1 INT, c2 INT, c3 INT);
GO
INSERT INTO t1 VALUES (1, 1, 1);
INSERT INTO t1 VALUES (1, 1, 2);
INSERT INTO t1 VALUES (1, 1, 3);
GO

ALTER DATABASE StatsTest
SET AUTO_CREATE_STATISTICS ON

SELECT * FROM t1 WHERE c3 < 2;
GO
SELECT [object_id], [name] FROM sys.stats
WHERE [object_id] = OBJECT_ID ('t1');
GO
object_id name
———– ————————–
۲۰۷۳۰۵۸۴۲۱ _WA_Sys_00000003_7B905C75

SELECT * FROM t1 WHERE c1 < 2;
GO
SELECT [object_id], [name] FROM sys.stats
WHERE [object_id] = OBJECT_ID ('t1');
GO
object_id name
———– ————————–
۲۰۷۳۰۵۸۴۲۱ _WA_Sys_00000003_7B905C75
۲۰۷۳۰۵۸۴۲۱ _WA_Sys_00000001_7B905C75