USE tempdb;
IF OBJECT_ID(N'dbo.Table1', N'U') IS NOT NULL
DROP TABLE dbo.Table1
GO
CREATE TABLE dbo.Table1
(
Table1ID int NOT NULL IDENTITY(1,1)
, Table1Data nvarchar(30) NOT NULL
);
CREATE INDEX IX_Table1
ON dbo.Table1 (Table1ID);
GO
INSERT INTO dbo.Table1 (Table1Data)
SELECT TOP(1000000) LEFT(c.name, 30)
FROM sys.columns c
CROSS JOIN sys.columns c1
CROSS JOIN sys.columns c2;
GO
SELECT *
FROM dbo.Table1
WHERE Table1ID = 500000;