avalie o script abaixo:

CREATE TABLE tHistModldOperCredt(
	nSoltcParm BIGINT NOT NULL IDENTITY(1, 1)
	,hInclRegHist DATETIME NOT NULL
	,cModldOperCredt INT NOT NULL
	,rModldOperCredt VARCHAR(50)NOT NULL
	,cIndcdSitReg INT NOT NULL
	,hInclReg DATETIME NOT NULL
	,hManutReg DATETIME NULL
	,CONSTRAINT PKtHistModldOperCredt PRIMARY KEY (
		nSoltcParm
		,hInclRegHist
		,cModldOperCredt
		)
	)

CREATE NONCLUSTERED INDEX IX_nSoltcParm_hInclRegHist ON tHistModldOperCredt(
	nSoltcParm
	,hInclRegHist
	)

CREATE NONCLUSTERED INDEX IX_cCartProdt_cProdt ON tHistModldOperCredt(
	cModldOperCredt
	,rModldOperCredt
	)

CREATE NONCLUSTERED INDEX IX_cIndcdSitReg ON tHistModldOperCredt(
	cIndcdSitReg
	)