> the database should be able to reorder the data in whatever way it likes
My point was that you’re trying to prevent the DB from reordering the data because there’s a performance cost when that happens.
My point was that you’re trying to prevent the DB from reordering the data because there’s a performance cost when that happens.
Sure. “Reduce the need” would be a better word than “prevent”.
If I can do a good job organizing the table columns (as described above) it’ll lower the need for the DB to reorder data.
Reduced need to reorder, improves performance.