IF IndexProperty(Object_Id('Cbtes'), 'IX_CBT_PorLotTrans', 'IndexID') IS NOT NULL
	DROP INDEX IX_CBT_PorLotTrans ON Cbtes
GO

CREATE NONCLUSTERED INDEX IX_CBT_PorLotTrans ON dbo.Cbtes
(
	Lote ASC,
	Id_Trans ASC
)  INCLUDE (Id_Estado_Cbte)
GO
