You may want to sort by settlement date instead of transaction date. There are plenty of examples where you need to sort before you can index: let's say you wan

You may want to sort by settlement date instead of transaction date. There are plenty of examples where you need to sort before you can index: let's say you want to create a spatial index. You first need to sort/group spatially (by tile) to query an area.