Confirmation regarding filtering on paginated queries
Just wanted to confirm how filtering works in a very specific scenario. When 1. not using an index and 2. using a paginated query, will applying a filter on this query perform a full table scan or just on the current page?