Hello,
Our DBA was running diagnostics on our production database server using sql-constanctcare and it identified the following db tables that would benefit from having the indexes identified below created. Because these are PSO databases, I wanted to get confirmation that this would be a recommended action to take.
Please advise.
Tool Used:
https://www.brentozar.com/sql-constantcare/
USE [SchedulingSystem]; CREATE NONCLUSTERED INDEX [message_group_id] ON [dbo].[Message] ([message_group_id]);
USE [ResourcePlanning]; CREATE NONCLUSTERED INDEX [organisation_id_dataset_id_ram_update_type_id] ON [dbo].[RAM_Update] ([organisation_id], [dataset_id], [ram_update_type_id]);
USE [Scheduling]; CREATE NONCLUSTERED INDEX [organisation_id_dataset_id_delete_flag_activity_id_input_reference_internal_id] ON [dbo].[Activity_Custom_URL] ([organisation_id], [dataset_id], [delete_flag], [activity_id], [input_reference_internal_id]);
USE [Scheduling]; CREATE NONCLUSTERED INDEX [organisation_id_dataset_id_delete_flag_activity_id_input_reference_internal_id] ON [dbo].[Activity_Skill] ([organisation_id], [dataset_id], [delete_flag], [activity_id], [input_reference_internal_id]);
USE [Scheduling]; CREATE NONCLUSTERED INDEX [organisation_id_dataset_id_delete_flag_activity_id_input_reference_internal_id] ON [dbo].[Activity_SLA] ([organisation_id], [dataset_id], [delete_flag], [activity_id], [input_reference_internal_id]);
USE [Scheduling]; CREATE NONCLUSTERED INDEX [load_status_input_datetime] ON [dbo].[Input_Reference] ([load_status], [input_datetime]);
Thanks,
Richard
