| ▲ | dspillett 3 hours ago | |
> If you need to list things ordered by creation time very often, it’s useful if the primary index gives that behavior, removing the need for another index. If you are using your primary key for anything other than a unique identifier for rows, you are almost certainly doing something wrong. If you need an index on creation time, or just creation order, have a creation time column and an index on that. | ||