CLIENT SUPPORT » Asuransi Bintang - Existing

dear tim developer mohon supportnya untuk tuning pada menu run statistic karena ada query yang tetep berjalan di db walau aplikasi nya sukses.
mengakibatkan pada submit ess menjadi loading muter2.

querynya

(@now nvarchar(4000),@instance nvarchar(5),@emp_id nvarchar(8),@reg_id nvarchar(4000),@empid_requester nvarchar(8),@userid_requester nvarchar(8))DECLARE @level_wanted AS VARCHAR = '03' DECLARE @ds_id AS VARCHAR = '' DECLARE @emp_data AS VARCHAR = @empid_requester DECLARE @ds_unit AS VARCHAR = '' DECLARE @ds_unitlevel AS VARCHAR = '' SELECT @ds_id = r1.ds1_id , @ds_unit = r2.unit , @ds_unitlevel = r2.unit_level FROM dbo.hr_bi_emp_om_recap r1 LEFT JOIN dbo.hr_bi_emp_om_recap r2 ON r2.emp_id = r1.ds1_id WHERE r1.emp_id = @emp_data WHILE ( @ds_unitlevel > @level_wanted ) BEGIN SELECT @ds_id = r1.ds1_id , @ds_unit = r2.unit , @ds_unitlevel = r2.unit_level FROM dbo.hr_bi_emp_om_recap r1 LEFT JOIN dbo.hr_bi_emp_om_recap r2 ON r2.emp_id = r1.ds1_id WHERE r1.emp_id = @ds_id END SELECT CASE WHEN @ds_id = @emp_data THEN 'admin' ELSE @ds_id END AS result

remote.minovais.com:312
database sql
remote.minovaois.com, 1452