Hints

import "gorm.io/hints"

db.Clauses(hints.New("hint")).Find(&User{})

import "gorm.io/hints"

db.Clauses(hints.UseIndex("idx_user_name")).Find(&User{})


db.Clauses(hints.ForceIndex("idx_user_name", "idx_user_id").ForJoin()).Find(&User{})


db.Clauses(
  hints.ForceIndex("idx_user_name", "idx_user_id").ForOrderBy(),
  hints.IgnoreIndex("idx_user_name").ForGroupBy(),
).Find(&User{})

import "gorm.io/hints"

db.Clauses(hints.Comment("select", "master")).Find(&User{})


db.Clauses(hints.CommentBefore("insert", "node2")).Create(&user)


db.Clauses(hints.CommentAfter("select", "node2")).Create(&user)


db.Clauses(hints.CommentAfter("where", "hint")).Find(&User{}, "id = ?", 1)