/*
Missing Index Details from SQLQuery5.sql - (local).HRIS (CORP\pribadi.pamungkas (68))
The Query Processor estimates that implementing the following index could improve the query cost by 92.1898%.
*/


USE [HRIS]
GO
CREATE NONCLUSTERED INDEX SPG_REPORT_ABSENSI_TIPE
ON [dbo].[SPG_REPORT_ABSENSI] ([TIPE])
INCLUDE ([NIP],[TANGGAL_ABSEN],[MOBILE_MASUK],[MOBILE_KELUAR])
GO

