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