Statistics, Data Distribution, and Cardinality - SQL Server Query Performance Tuning - page 198

IF (SELECT OBJECT_ID('dbo.Test1')
) IS NOT NULL
DROP TABLE dbo.Test1;
GO
CREATE TABLE dbo.Test1
(Test1_C1 INT IDENTITY,
Test1_C2 INT
);
INSERT INTO dbo.Test1
(Test1_C2)
VALUES (1);
SELECT TOP 10000
IDENTITY( INT,1,1 ) AS n
INTO #Nums
FROM Master.dbo.SysColumns scl,
Master.dbo.SysColumns sC2 ;
INSERT INTO dbo.Test1
(Test1_C2)
SELECT 2
FROM #Nums
GO
CREATE CLUSTERED INDEX i1 ON dbo.Test1(Test1_C1)
--Create second table with 10001 rows, -- but opposite data distribution IF(SELECT
0BJECT_ID('dbo.Test2')) IS NOT NULL
IF (SELECT OBJECT_ID('dbo.Test2')
) IS NOT NULL
DROP TABLE dbo.Test2;
GO
CREATE TABLE dbo.Test2
(Test2_C1 INT IDENTITY,
Test2_C2 INT
);
INSERT INTO dbo.Test2
(Test2_C2)
VALUES (2);
INSERT INTO dbo.Test2
(Test2_C2)
SELECT 1
FROM #Nums;
DROP TABLE #Nums;
GO
CREATE CLUSTERED INDEX il ON dbo.Test2(Test2_C1);