I have tried statistics update, drop/re create index, created new db and imported all the data,restored the same database again,wrapped the view in another view which the query is accessing,creates TVF (function)....

all of the above didnt change the query plan.

If it matters with the amount of data, i owuld expect smaller db to finish the query fastert than bigger one, but its reverse, any explanation?