cancel
Showing results for 
Search instead for 
Did you mean: 

Magento 1.9: Any Methods For Adding Hints to SQL Queries

Magento 1.9: Any Methods For Adding Hints to SQL Queries

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 ?