When should you filter?
Filtering records works like a query, bringing up specific information from a table.
But unlike a query, your filtering doesn't remain part of the database.
When you perform a query and save it, the query remains with the database, even after you close it. Filtering does not.
Since you can't save filtering like a query, filter records when you need quick results. Think of filtering as a temporary, quick, "on the spot" query.