IF NOT EXISTS (SELECT * FROM SYS.INDEXES WHERE NAME = 'IX_EST_NF_SAI_DT_EMI_NF_STS_NF')
BEGIN	

CREATE NONCLUSTERED INDEX IX_EST_NF_SAI_DT_EMI_NF_STS_NF
ON [dbo].[EST_NF_SAI] ([CD_EMP],[DT_EMI_NF],[STS_NF])
INCLUDE ([CD_FILIAL],[CD_NF])

	WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, 
		SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, 
		ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, 
		FILLFACTOR = 90) 
END

