asked on June 29, 2022
•
Show version history
Our DBAs have reached out to me to let me know that they have received a recommendation to create a nonclustered index on the cf_bp_worker_instnc_to_resume_archive table by the Query Processor. Would there be a problem with them adding this? See the message below:
/* Missing Index Details from ExecutionPlan3.sqlplan The Query Processor estimates that implementing the following index could improve the query cost by 25.1568%. */ /* USE [Forms] GO CREATE NONCLUSTERED INDEX [<Name of Missing Index, sysname,>] ON [dbo].[cf_bp_worker_instnc_to_resume_archive] ([worker_instance_id],[step_id]) GO */ (@p__linq__1 int,@p__linq__2 nvarchar(4000),@p__linq__0 datetime2(7))SELECT TOP (100) [Project22].[id] AS [id], [Project22].[history_id] AS [history_id], [Project22].[instance_id] AS [instance_id], [Project22].[step_id] AS [step_id], [Project22].[process_id] AS [process_id], [Project22].[origin_step_name] AS [origin_step_name], [Project22].[creation_date] AS [creation_date], [Project22].[last_assigned_start_date] AS [last_assigned_start_date], [Project22].[last_assigned_finish_date] AS [last_assigned_finish_date], [Project22].[last_assigned_resume_id] AS [last_assigned_resume_id], [Project22].[last_assigned_status] AS [last_assigned_status], [Project22].[last_assigned_target_snapshot] AS [last_assigned_target_snapshot], [Project22].[last_assigned_team_id] AS [last_assigned_team_id], [Project22].[last_assigned_owner_snapshot_id] AS [last_assigned_owner_snapshot_id], [Project22].[bp_id] AS [bp_id], [Project22].[status] AS [status], [Project22].[due_date] AS [due_date], [Project22].[finish_date] AS [finish_date] FROM ( SELECT [Project22].[C1] AS [C1], [Project22].[C2] AS [C2], [Project22].[id] AS [id], [Project22].[history_id] AS [history_id], [Project22].[instance_id] AS [instance_id], [Project22].[step_id] AS [step_id], [Project22].[process_id] AS [process_id], [Project22].[origin_step_name] AS [origin_step_name], [Project22].[creation_date] AS [creation_date], [Project22].[last_assigned_start_date] AS [last_assigned_start_date], [Project22].[last_assigned_finish_date] AS [last_assigned_finish_date], [Project22].[last_assigned_resume_id] AS [last_assigned_resume_id], [Project22].[last_assigned_status] AS [last_assigned_status], [Project22].[last_assigned_target_snapshot] AS [last_assigned_target_snapshot], [Project22].[last_assigned_team_id] AS [last_assigned_team_id], [Project22].[last_assigned_owner_snapshot_id] AS [last_assigned_owner_snapshot_id], [Project22].[bp_id] AS [bp_id], [Project22].[status] AS [status], [Project22].[due_date] AS [due_date], [Project22].[finish_date] AS [finish_date], row_number() OVER (ORDER BY [Project22].[C1] ASC, [Project22].[C2] ASC) AS [row_number] FROM ( SELECT CASE WHEN ([Project21].[due_date] IS NOT NULL) THEN [Project21].[due_date] ELSE @p__linq__0 END AS [C1], CASE WHEN ([Project21].[C1] IS NOT NULL) THEN [Project21].[C2] WHEN ([Project21].[C3] IS NOT NULL) THEN [Project21].[C4] ELSE [Project21].[origin_step_name] END AS [C2], [Project21].[id] AS [id], [Project21].[history_id] AS [history_id], [Project21].[instance_id] AS [instance_id], [Project21].[step_id] AS [step_id], [Project21].[process_id] AS [process_id], [Project21].[origin_step_name] AS [origin_step_name], [Project21].[creation_date] AS [creation_date], [Project21].[last_assigned_start_date] AS [last_assigned_start_date], [Project21].[last_assigned_finish_date] AS [last_assigned_finish_date], [Project21].[last_assigned_resume_id] AS [last_assigned_resume_id], [Project21].[last_assigned_status] AS [last_assigned_status], [Project21].[last_assigned_target_snapshot] AS [last_assigned_target_snapshot], [Project21].[last_assigned_team_id] AS [last_assigned_team_id], [Project21].[last_assigned_owner_snapshot_id] AS [last_assigned_owner_snapshot_id], [Project21].[bp_id] AS [bp_id], [Project21].[status] AS [status], [Project21].[due_date] AS [due_date], [Project21].[finish_date] AS [finish_date] FROM ( SELECT [Project19].[id] AS [id], [Project19].[history_id] AS [history_id], [Project19].[instance_id] AS [instance_id], [Project19].[step_id] AS [step_id],
Using Forms 10.4.4.444.
0
0