Hi,

Our DBA team have recently run a missing index recommendation check on our Laserfiche DB's and came back with the below results. I would like to find out if there is any risk in them proceeding to create indexes for these?

Is there also perhaps some white paper available that explains from a Best Practice point of view, what are the recommended indexes to be created?

1.
/*
Missing Index Details from ExecutionPlan1.sqlplan
The Query Processor estimates that implementing the following index could improve the query cost by 99.6345%.
*/

/*
USE [AFSLaserfiche]
GO
CREATE NONCLUSTERED INDEX [<Name of Missing Index, sysname,>]
ON [dbo].[propval] ([prop_id])
INCLUDE ([tocid],[short_str_val])
GO
*/

2.
/*
Missing Index Details from ExecutionPlan1.sqlplan
The Query Processor estimates that implementing the following index could improve the query cost by 43.9698%.
*/

/*
USE [AFSLaserfiche]
GO
CREATE NONCLUSTERED INDEX [<Name of Missing Index, sysname,>]
ON [dbo].[toc] ([pset_id],[tocid])
INCLUDE ([parentid],[toc_flags])
GO
*/

3.

/*
Missing Index Details from ExecutionPlan1.sqlplan
The Query Processor estimates that implementing the following index could improve the query cost by 99.5937%.
*/

/*
USE [AFSLaserficheWF]
GO
CREATE NONCLUSTERED INDEX [<Name of Missing Index, sysname,>]
ON [dbo].[bp_step] ([bps_report_id],[bps_end_date])
INCLUDE ([bps_start_date])
GO
*/