CODEWITHSUNDEEP
sqlsql-server-2005optimization
Ramesh Soni
Ramesh Soni

Reputation: 16077

What is the most optimized way to write a paged query in SQL Server 2005?

I know several ways of writing paged query in SQL Server 2005. But I have no idea about their performance. Which one is the best and most optimized way for writing paging SQL queries?

  1. Using Row_Number()
  2. Using Partition by
  3. Using Temporary tables
  4. Using Nest Top N with Order by
  5. Some other way?

Upvotes: 1

Views: 250

Answers (1)

Mark S. Rasmussen
Mark S. Rasmussen

Reputation: 35476

In my experience it's using ROW_NUMBER(), just make sure the orderby field is the clustered index so you won't have to pay penalties for sorting the dataset on each query.

Upvotes: 3

Related Questions