Best way to use MySQL clause "Use index('index_name')" using ActiveRecord

Question

I want to use the SQL clause "Use index('index_name')" to an ActiveRecord query, does anyone knows a good way to do it with Activerecord I wanted to avoid adding string directly to the query.

Answer 1

I use this in my models:

def self.use_index(index)
  from("#{self.table_name} USE INDEX(#{index})")
end