2 ms·
Another benefit of having a separate status field is that you can index it easily. You could technically index the timestamps, but it's a lot of busywork for th
by orthoxerox 4y ago
Another benefit of having a separate status field is that you can index it easily. You could technically index the timestamps, but it's a lot of busywork for the RDBMS, as the values are all distinct.
- wruza 4y agoThis is orthogonal, because expressions can be indexed too. Of course if you see the same expression three+ times in your code, it’s begging for a name.