What will be done with the 10,000 records per page that you speak of? Do you expect a human to read them?

A: This is not for user but for internal...

Around 400000 records in the table [and can grow in future]. If we need 10000 records per page, we would like to avoid extra processing of rest of the records.

It's not like finding better way to implement row_numer. My query is like this:

select col1, col2, col3

from (select row_number() over (order by a.col1, a.col2) as 'rownum', a.col1, a.col2, a.col3

from table1...

And in case of migration ?

Oops my mistake, Its for GSquared....

Is there anything to take care of with respect to login transfer ?

Thanks Adiga

Thanks Gila, That's exactly what I was looking for.