[fabian2k]

The database argument is also specific to certain databases and table types. It should only matter for clustered tables. So if e.g. I use Postgres, this doesn't matter as it doesn't have clustered tables.

[erik_seaberg]

Distributed databases rely on spread across possible keys to balance workload. Mostly-ordered keys create hotspots.