Discussion between ypercubeᵀᴹ and Royi Namir

Imported from a comment discussion on http://dba.stackexchange.com/questions/130751/index-seek-is-not-used-unless-option-recompile