/* jueves, 3 de octubre de 202402:03:49 User: ALFANET Server: SERVER-ALFAVB6 Database: DICASUR 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.*/ 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 GO CREATE NONCLUSTERED INDEX IX_V_MV_TROPA_STOCK ON dbo.V_MV_TROPA_STOCK ( nroRemito ) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO CREATE NONCLUSTERED INDEX IX_V_MV_TROPA_STOCK_1 ON dbo.V_MV_TROPA_STOCK ( fecha ) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO ALTER TABLE dbo.V_MV_TROPA_STOCK SET (LOCK_ESCALATION = TABLE)