Index on multiple columns in Ruby on Rails

by

The order does matter in indexing.

  1. Put the most selective field first, i.e. the field that narrows down the number of rows fastest.
  2. The index will only be used insofar as you use its columns in sequence starting at the beginning. i.e. if you index on [:user_id, :article_id], you can perform a fast query on user_id or user_id AND article_id, but NOT on article_id.

Your migration add_index line should look something like this: 

add_index :user_views, [:user_id, :article_id]

Question regarding ‘unique’ option

An easy way to do this in Rails is to use validates in your model with scoped uniqueness as follows (documentation):

validates :user, uniqueness: { scope: :article }

More Related Contents:

  1. Format a string containing Phone numbers
  2. Best way to load module/class from lib folder in Rails 3?
  3. Rails order by results count of has_many association
  4. No route matches [GET] /assets
  5. rails 3 – link_to to destroy not working
  6. file download link in rails
  7. Rails — use type column without STI?
  8. Why doesn’t `config.time_zone` seem to do anything?
  9. Rails 3, has_one / has_many with lambda condition
  10. Rails update_attributes without save?
  11. Rails – How to use a Helper Inside a Controller
  12. Pass a variable into a partial, rails 3?
  13. Installing Postgres on windows for use with Ruby-on-Rails
  14. Using send_file to download a file from Amazon S3?
  15. Validate uniqueness of multiple columns
  16. Remove ActiveRecord in Rails 3
  17. Rails auto-assigning id that already exists
  18. Use rvmrc or ruby-version file to set a project gemset with RVM?
  19. Rails – Validate Presence Of Association?
  20. Devise + Omniauth – How to pass extra parameters along?
  21. Rails 3.1 and Image Assets
  22. What does do in rails erb?
  23. Counter Cache for a column with conditions?
  24. How to add bootstrap modal with link_to so the link content open in modal ?
  25. How do I extract Rails view helpers into a gem?
  26. Passing variables inside rails internationalization yml file
  27. How to make Devise redirect after confirmation
  28. Rails devise: user_signed_in? not working
  29. rails 3 has_many :through Form with checkboxes
  30. Customizing Devise error messages in Rails 3?

Leave a Comment