Efficient way to paginate in sql server with 50M plus data (sql server 17)
There is simply no cheap way to get the 12753rd page out of a 50M row result set.


  [offset .. fetch] works fine for small offset. But, as the offset value increase. It gradually starts to take a lot of time.


Which is normally fine, as you rarely page deep into a large result set.


  [The "Key Seek Method"] failed when you want to move from page 1 to page 3.


Yep.  But it's so much more efficient that you simply avoid skipping pages.