cancel
Showing results for 
Search instead for 
Did you mean: 

Magento 1.9: Any Methods For Adding Hints to SQL Queries

   Did you know you can see the translated content as per your choice?

Translation is in progress. Please check again after few minutes.

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 ?