ERROR | query rewrite not possible with materialized view string because it contains a join between tables (string) that is not present in the query and that potentially eliminates rows needed by the query |
CAUSE | All lossy joins in the materialized view must be present in the query for query rewrite to occur. |
ACTION | None |