• For that specific query your index design doesn't make much sense. Also I wouldn't create indexes on tables with only a few rows. You may want to drop your indexes and create a new one something like

    CREATE NONCLUSTERED INDEX ix_GMFPick_IdNo ON GMFPick (IDNo) INCLUDE (EmployeeIDNo,PickDt,ProductIDNo,CustomerIDNo,HouseIDNo)