Sorted Tables for Faster Range-Scans
“Most developers will use an automatically incrementing column for the primary key with insertion-order sorting for the table’s data by default. However, rows belonging together are stored in the database file very far away, resulting in many disk fetch operations. When instead e.g.”
read »