• You can't use OR in the where clause of a filtered index.

    The non-filtered one is ignored as having VehReg in the index key isn't helpful to that query.

    An indexed view may serve you better here. Note there are caveats to using them:

    http://msdn.microsoft.com/en-us/library/ms191432(v=sql.105).aspx

    Or try separate indexes - one on (Meter, Ver1, Ver2) and the other on VehReg, both with the included columns SurroID, CodeNr, VehReg, CompID, SentDate.

    Might be a bit hit and miss as to whether the optimiser uses both indexes though.