|
|
|
|
|
|
by pdhborges
1296 days ago
|
|
|
For these 64-bit index entries we’d expect to have to scan roughly:
index_row_size⋅rows=2⋅64bit⋅10^5=1.5MiB
Where do the 10^5 rows come from? With a composite index and a point query doesn't the database scan just the 100 returned rows? |
|
|
I forgot to move this around when I updated the article's structure. This is only relevant when doing the index merge. The article has been updated