...
Materialized View | Fast Refreshable? | Reason | |
|---|---|---|---|
BANNER_ACADEMICSESSION | Yes |
| |
BANNER_COURSESET |
| No | UNION Clauses used that assemble non-identical data |
BANNER_CANONICALCOURSE | NeverNo | Distinct Clause in Query, SCBCRSE has no primary key | |
BANNER_CANON_COURSESETS | NeverNo | Distinct Clause in Query, SCBCRSE has no primary key | |
BANNER_COURSEOFFERING | NeverNo | Distinct Clause in Query, SCBCRSE has no primary key | |
BANNER_OFFERING_COURSESETS |
| No | UNION Clauses used that assemble non-identical data |
BANNER_CM_SECTION | Yes |
| |
BANNER_ENROLLMENTSET | Yes |
| |
BANNER_INSTRUCTORS | No | Distinct Clause in Query | |
BANNER_ENROLLMENT | Yes |
| |
BANNER_MEETING | No | Distinct Clause in Query, SSRMEET has no primary key |