As requested by Yavor Angelov from MSFT via Twitter im writing down what seem to to be my biggest pains with QO in SqlServer.
1) Whenever you have a a join between large tables QO will look at the indexes that exists on the join keys. If some indexes are missing it seems that the [...]