/* jueves, 07 de abril de 202204:20:23 User: sa Server: SERVER-ALFAVB6 Database: ALFANET Application: */ /* To prevent any potential data loss issues, you should review this script in detail before running it outside the context of the database designer.*/ BEGIN TRANSACTION SET QUOTED_IDENTIFIER ON SET ARITHABORT ON SET NUMERIC_ROUNDABORT OFF SET CONCAT_NULL_YIELDS_NULL ON SET ANSI_NULLS ON SET ANSI_PADDING ON SET ANSI_WARNINGS ON COMMIT BEGIN TRANSACTION GO CREATE NONCLUSTERED INDEX IX_V_MA_eMailMov_1 ON dbo.V_MA_eMailMov ( TC, IdComprobante, Cuenta ) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO CREATE NONCLUSTERED INDEX IX_V_MA_eMailMov_2 ON dbo.V_MA_eMailMov ( FechaHora ) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO ALTER TABLE dbo.V_MA_eMailMov SET (LOCK_ESCALATION = TABLE) GO COMMIT