3 ms·
> 128 bits vs. 64 bits doesn't matter much when the table has five other columns. !!!! But those 5 other columns are not indexed. --- There are three levels
by paulddraper 3y ago
> 128 bits vs. 64 bits doesn't matter much when the table has five other columns.
!!!!
But those 5 other columns are not indexed.
---
There are three levels of database performance:
1. Indices and data fit in memory.
2. Indices fits in memory, data does not.
3. Neither indices not data fit in memory.
If you can do #1 great, but if you don't have that, fight like a madman for #2.
---
Doubling your index sizes is just makes it harder.