This suggests that not all the MV data is cached and it still queries the source tables in some way?
No. That isn’t how MV work. If you include an MV relation in your query from clause there is no reference or knowledge as to the underlying query that built the MV physical relation.
David J.
