There’s a command to force it to update table statistics… you just run that, especially after doing manual stuff. Pretty common, but easy to forget.