sql - Performance tuning of this query? -

i have below query support employee pagination sorted employee name

select rownumalias     ,employee.employeeid     ,employee.name (     select row_number() on (             order employee.name asc             ) rownumalias         ,employeeid         ,name     employee     ) employeedata inner join employee on employee.employeeid = employeedata.employeeid rownumalias between ? , ? 

where parameter rownumalias can integer number between 1 , 100

this query taking around 7 seconds on sql server database having 1 million records. is there way can minimize query execution time ?

you can try this:

select * ( select (select row_number() on (order e2.name asc) employee e2 employee.employeeid = e2.employeeid) rownumalias,     ,employee.employeeid     ,employee.name employee  ) e3 e3.rownumalias between ? , ?