The solution is to use SQL views, materialized views, or create a new table that contains only the filtered data the user needs. ... Here’s an example of when you should use materialized views.