In my case problem was using views in the query. When switching to use the raw tables, subquery was used without any hints.