CREATE PROC QOD_Performance_1
   @Get NVARCHAR(20)
AS
 SELECT ID,Col
  FROM FirstTable WITH (FORCESEEK)
  WHERE Col = @Get; 
GO
EXECUTE dbo.QOD_Performance_1
    @Get = N'XYZ'

CREATE TABLE TestTable (ID INT, Col VARCHAR(100));
GO
CREATE INDEX IX_Col ON TestTable (Col);
GO

CREATE PROCEDURE Test_Procedure
@Get NVARCHAR(20)
AS
SELECT ID, Col
FROM TestTable
WHERE Col = @Get;

DECLARE @int INT;
SET @int = 1;

WHILE @int <100
BEGIN

INSERT INTO TestTable (id, col)
VALUES (@int, 'name' + CAST(@int AS VARCHAR(100)));

SET @int += 1;

END

DECLARE @int INT;
SET @int = 1;

WHILE @int <=1000
BEGIN

INSERT INTO TestTable (id, col)
VALUES (@int, 'name' + CAST(@int AS VARCHAR(100)));

SET @int += 1;

create table dbo.Tally(i int identity(1,1))
go
insert into dbo.Tally DEFAULT VALUES
go 1000000