Non clustered index IX_tblControlNumber_VT-PId-CN added on tblControlNumbers

hirensoni913 · hirensoni913 · commit ad488e5cb3a6 · 2022-04-13T12:40:33.000+03:00
diff --git a/sql/base/4_alter_schema.sql b/sql/base/4_alter_schema.sql
@@ -678,3 +678,9 @@ ALTER TABLE [dbo].[tblProduct]  WITH NOCHECK ADD  CONSTRAINT [CHK_Weight] CHECK
 GO
 ALTER TABLE [dbo].[tblProduct] CHECK CONSTRAINT [CHK_Weight]
 GO
+IF NOT EXISTS(SELECT 1 FROM sys.indexes WHERE name = N'IX_tblControlNumber_VT-PId-CN')
+BEGIN
+	CREATE NONCLUSTERED INDEX [IX_tblControlNumber_VT-PId-CN]
+	ON [dbo].[tblControlNumber] ([ValidityTo],[PaymentID],[ControlNumber])
+END
+GO
