I'd like to add a hint to speed up my query:
SELECT * FROM t1 LEFT JOIN t2 USE INDEX (idx) ON t1.id = t2.id
I understand, I can write such query with my hands.
Is it possible to do this using Magento 1.9 methods, for example, based on Varien_Db_Adapter_Interface ?