Can someone explain how different sorting orders in Lemmy work?

There are some details in the docs. I also saw a post somewhere about plans for changes but I saved in on a now defunct lemmy server and now I can't find it.