When we want to use row number function in cte is less efficient in paging instead of we can use temp table and create index on row number column.
When cte is use for paging than we need to use rownumber function. But we can create temp table and included with row number column and create index on row number column than sql will perform index seek within the index to reach low boundary row until it reaches the high boundary row.
By using temp table Only the rows of the requested page of results are scanned within the index. While in Cte Index scan is performed and it scans from first row.
So, i want to know that is it right or not?