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



CREATE NONCLUSTERED INDEX IX_CBT_PorLotFec ON Cbtes
	(
	Lote ASC,
	Fecha ASC
	)
	INCLUDE (
	Id_Trans,
	Id_Estado_Cbte,
	Id_Cliente,
	Destinatario,
	Imp_Total
	)
GO
