crie indices para a tabela:

CREATE TABLE tHistAgptoModldSubmodld (
	nSoltcParm BIGINT NOT NULL IDENTITY(1, 1)
	,hInclRegHist DATETIME NOT NULL
	,cModldOperCredt INT NOT NULL
	,cSmdldOperCredt INT NOT NULL
	,cIndcdSitReg INT NOT NULL
	,hInclReg DATETIME NOT NULL
	,hManutReg DATETIME NULL
	,nParmConslCli BIGINT NOT NULL DEFAULT 0
	,rSmdldOperCredt VARCHAR(50) NOT NULL
	,CONSTRAINT PKtHistAgptoModldSubmodld PRIMARY KEY (
		nSoltcParm
		,hInclRegHist
		,cModldOperCredt
		,cSmdldOperCredt
		)
	)