index (ActiveRecord::ConnectionAdapters::Table)

Table#index - This method does not work. #rails

When using the index method within a create_table statement, it does not have any side effect - at least not in MySQL. create_table :comment do | t | t . belongs_to :post t . timestamps # not working inside create_table ! t . index :post_id end It is working properly in change_table though change_table :comment do | t | t . belongs_to :user # this works inside change_table t . index :user_id end Unfortunately this flaw is not reported in any way. The index is just not created. I have only tested this with the mysql2 driver in Rails 2.3.x. I’m not sure, if this happens in other versions/adapters as well.

Full article: http://apidock.com/rails/ActiveRecord/ConnectionAdapters/...