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

[sql] 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 [/sql]

[sql]
ALTER DATABASE StatsTest
SET AUTO_CREATE_STATISTICS ON [/sql]

[sql] SELECT * FROM t1 WHERE c3 < 2;
GO

SELECT [object_id], [name] FROM sys.stats
WHERE [object_id] = OBJECT_ID (‘t1’);
GO

object_id name
———– ————————–
2073058421 _WA_Sys_00000003_7B905C75 [/sql]

[sql] SELECT * FROM t1 WHERE c1 < 2;
GO

SELECT [object_id], [name] FROM sys.stats
WHERE [object_id] = OBJECT_ID (‘t1’);
GO

object_id name
———– ————————–
2073058421 _WA_Sys_00000003_7B905C75
2073058421 _WA_Sys_00000001_7B905C75 [/sql]