Efficient paging with large tables in sql 2008
- by Kumar
for tables with 1,000,000 rows and possibly many many more !
haven't done any benchmarking myself so wanted to get the experts opinion.
Looked at some articles on row_number() but it seems to have performance implications
What are the other choices/alternatives ?