IF NOT EXISTS (SELECT * FROM SYS.INDEXES WHERE NAME = 'IX_PDV_VD_DEV_EST_PROD_IMP_DT_DEVO')
BEGIN	
	CREATE NONCLUSTERED INDEX [IX_PDV_VD_DEV_EST_PROD_IMP_DT_DEVO] ON 
		[dbo].[PDV_VD_DEV_EST_PROD_IMP] ([CD_EMP],[DT_DEVO])
		INCLUDE(VLR_IT, 		QT_IT, 		VLR_IT_BRUTO, 		VLR_DESC_IT, 		
				VLR_PMC_IT, 		VLR_DESC_VERBA, 		VLR_CUSTO_MEDIO, 		VLR_CUSTO)

	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

	