Hi ratbak,

* yes i meant clustered index.

* yes, there are 5 more indexes

* we are running SQL 2014 and compatability Level is 140

* and YES the 2 execution plans are...

Hi Phil,

thats correct, yesterday and today, and every day about 15 times for each query

It did the trick,

was exactly what i needed

Thank you