3 ms·
> and rather than doing random reads to satisfy them, just read the whole table sequentially OK, good point, I believe this is called a carousel read (spent 5
by tempguy9999 7y ago
> and rather than doing random reads to satisfy them, just read the whole table sequentially
OK, good point, I believe this is called a carousel read (spent 5 mins looking for a link, sorry no luck. I know MSSQL does a slightly fancier version of it).
I think the original article was unclear in what it was trying for, actual performance or exposition.
Edit: could have utterly sworn it was a carousel read, but no cigar. Here it is https://www.mssqltips.com/sqlservertip/4472/sql-server-enterprise-advanced-scan-aka-merrygoround-scan/ https://www.mssqltips.com/sqlservertip/4472/sql-server-enter...
- nunwuo 7y agoPostgres does this, too; at least to some degree. They call it "synchronized sequential scans".