Hi,

"

As far as I remember, aggregate functions also do
not use indexes and will get progressively slower over time."

for min/max index is used if you have ascending for MIN and descending for MAX.

About topic itself. I always use numbering table and i raly on transaction conflicts.

You know if you update table other transaction get conflict until you commit.

Regards,