On Mar 29, 7:51 pm, RVRoadie <[email protected]> wrote: > I created an index with person_id and club_id but I can't figure out > how to properly access it (doesn't show up in the find_by... lists) > > Can someone provide me a sample find statement to best use this index
You don't need to do anything explicitly - just find :all, :conditions => ... will use the index if needed (you may have been looking for find_by_xxx_and_yyy though) The index on person_id is usually superfluous - when you have a multicolumn index then any left prefix of that index is also an index ie the index on [:person_id, :club_id] can be used as an index on just person_id Fred > > Thanks. > > class CreateMembers < ActiveRecord::Migration > def self.up > create_table :members do |t| > t.integer :club_id > t.integer :person_id > t.text :comment > t.string :status > t.string :member_type > t.integer :registrations_count > > t.timestamps > end > > add_index :members, :club_id > add_index :members, :person_id > add_index :members, [:person_id, :club_id] > end > > def self.down > drop_table :members > end > end -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
