You need two indexes because of the or
One index on Primary, one on Secondary. You may need to make both covering, depends on the rows involved. test and see
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability