Rails数据库索引 #

# 迁移中创建索引
class AddIndexesToArticles < ActiveRecord::Migration[7.1]
  def change
    add_index :articles, :title
    add_index :articles, :user_id
    add_index :articles, [:user_id, :status], name: 'index_articles_on_user_and_status'
  end
end

add_index :users, :email, unique: true

add_index :articles, [:user_id, :status, :created_at]

add_index :articles, :title

add_index :articles, :body, using: :gin