Rows can be stored in an already sorted way, instead of the default insertion order

Rows can be stored in an already sorted way, instead of the default insertion order

⚡️ Database Tip

In most applications, all rows are physically sorted in the database file by their insertion order. By sorting them instead optimally for your application a huge databases will still be amazingly fast.

https://sqlfordevs.io/sorted-table-faster-range-scan

We're writing a book, you can get it for free here.