> 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.
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-enter...