account that "FORCE INDEX" disables full table scans, and not range/index_merge scans.
(with post-review fixes)