Post #1768959
2026-03-01 20:32 UTC
@TimWardCam
Nope explain doesn't tell you which index you should create. It just tells you what the query planner does.
Replies (2)
-
@TimWardCam@c.im 2026-03-01 20:33
@bohwaz It's often enough blindingly obvious what you should do about it - I did say "less directly".
-
@TheConstructor@social.tchncs.de 2026-03-02 07:07
@bohwaz @TimWardCam in SQL Server query plan gives you the CREATE INDEX SQL, if it thinks it's badly needed