3 ms·
Yes, but... You might have many, many sequentially related records in one 4k block of an index retrieved from a SSD. Maybe 200. Then in turn you can retrieve
by mlyle 7y ago
Yes, but...
You might have many, many sequentially related records in one 4k block of an index retrieved from a SSD. Maybe 200. Then in turn you can retrieve those index blocks sequentially and get a performance improvement.
In turn, when you're doing a merge or bitmap scan over the index, this can make a really big difference.