[RESOLVED] Applying an index to a field

[the182guy]

I've got a table like this

SalesOrderId(PK)
OrderDate
SalesPersonId (FK1, l1)
StoreID (FK3, l3)
TerritoryID (FK2, l2)

I want to apply an index to make my query faster/more effecient.

The query is pulling out the SalesOrderId,OrderDate and StoreID WHERE StoreID=X

Would it be best to apply an index to StoreID, would it improve performance?

Cheers