My MailingAddress table currently has a Non Clustered index on the ProcessID column. Using a Missing Indexes query I have, it is recommending that I add the following:
CREATE INDEX [IX_MailingAddress_ProcessID_PrintFlag] ON [DB1].[dbo].[MailingAddress] ([ProcessID], [PrintFlag]) INCLUDE ([RunNum])
I am under the impression that I should either delete the existing index on ProcessID and add this one or should I add the suggested index while keeping the index only on ProcessID as well?
Thanks for the help!!