searches all updated to utilise materialized views