Skip to main content

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

Be the first to reply!

Reply