No, i will pass first and last index ranges.
Let me put this way.
if my query can return 200 records, i should retrieve 50 records at a time instead of retrieving all the 200 records at a time.
This will help me if my query has chances to return 100,000 records.
So in that scenario, my application performance drastically come down.
So to aviod that first i will get only first 50 records first and show it, when user clicks next button i will get next 50 records from DB and display and so on.