/*
Missing Index Details from SQLQuery1.sql - CONDBDSSI01\CONDBDSSI.OJK SIRDK (dbsirdk (158))
The Query Processor estimates that implementing the following index could improve the query cost by 20.1518%.
*/


USE [OJK SIRDK]
GO
CREATE NONCLUSTERED INDEX IX_TopikIdTopikJenisRapatId
ON [Transaction].[Topik] ([TopikLogId],[TopikStatus],[TopikTanggalRdkBS])
INCLUDE ([TopikId],[TopikJenisRapatId])
GO

-----------------------------------------------------------------------------------------------------------------

/*
Missing Index Details from SQLQuery1.sql - CONDBDSSI01\CONDBDSSI.OJK SIRDK (dbsirdk (158))
The Query Processor estimates that implementing the following index could improve the query cost by 12.5311%.
*/


USE [OJK SIRDK]
GO
CREATE NONCLUSTERED INDEX IX_AssignmentId
ON [Transaction].[Assignments] ([AssignmentFinishDate])
INCLUDE ([AssignmentId])
GO

-----------------------------------------------------------------------------------------------------------------

/*
Missing Index Details from SQLQuery1.sql - CONDBDSSI01\CONDBDSSI.OJK SIRDK (dbsirdk (158))
The Query Processor estimates that implementing the following index could improve the query cost by 17.6452%.
*/


USE [OJK SIRDK]
GO
CREATE NONCLUSTERED INDEX IX_AssignmentIdAssignmentTopikIdAssignmentStatusAssignmentFinishDate
ON [Transaction].[Assignments] ([AssignmentDate])
INCLUDE ([AssignmentId],[AssignmentTopikId],[AssignmentStatus],[AssignmentFinishDate])
GO

