Q: The database optimizer suggest multiple indexes. I select them all and choose to add, but then I get errors like this:

COM error during Creating missing index with statement CREATE INDEX [ac_idx_tbl_SystemJobInfo_38DF8B2ACA809DB5914888458 DE3BD6F] ON [RPMEE].[dbo].[tbl_SystemJobInfo] ([idJobID]):
Code: 0x80040E14
Code meaning: IDispatch error #3092
Source: Microsoft OLE DB Provider for SQL Server
Description: The operation failed because an index or statistics with name 'ac_idx_tbl_SystemJobInfo_38DF8B2ACA809DB591488845 8DE3BD6F'
already exists on table 'RPMEE.dbo.tbl_SystemJobInfo'.
Number = -2147217900
Source = Microsoft OLE DB Provider for SQL Server
Description = The operation failed because an index or statistics with name 'ac_idx_tbl_SystemJobInfo_38DF8B2ACA809DB591488845 8DE3BD6F' already exists on table 'RPMEE.dbo.tbl_SystemJobInfo'.
SQLState = 42S11
Native Error= 1913
A: This happens if the index optimizer suggests multiple indexes for the same tables and all of the suggestions are selected and selected for addition. The problem is then that when adding one index, others are removed as they were simply other potential choices for the same table. If they choosing to add one at a time, the secondary choices get removed and the selected indexes are added without incident. Generally, the indexes with the largest improvement number should be selected for addition first.