When testing stored procedures in SSMS, it sometimes says there is a missing index on
#someTempTable____________________000000000000005B] (someField) etc etc
When I do add them like this to the sp:
CREATE NONCLUSTERED INDEX [<Name of Missing Index, sysname,>] ON [dbo].[#someTable] ([someField]) GO
I never seem to see a speed improvement. So, I often do not add such indexes. When should I be adding such indexes?