...
Materialized View | Fast Refreshable? | Reason | Refresh Interval | |
|---|---|---|---|---|
BANNER_ACADEMICSESSION | Yes |
| 1 Day | |
BANNER_COURSESET | No | UNION Clauses used that assemble non-identical data | 30 Days | |
BANNER_CANONICALCOURSE | No | Distinct Clause in Query, SCBCRSE has no primary key | 30 Days | |
BANNER_CANON_COURSESETS | No | Distinct Clause in Query, SCBCRSE has no primary key | 30 Days | |
BANNER_COURSEOFFERING | No | Distinct Clause in Query, SCBCRSE has no primary key | 7 Days | |
BANNER_OFFERING_COURSESETS | No | UNION Clauses used that assemble non-identical data | 7 Days | |
BANNER_CM_SECTION | Yes |
| 60 Minutes | |
BANNER_ENROLLMENTSET | Yes |
| 60 Minutes | |
BANNER_INSTRUCTORS |
| No | Distinct Clause in Query |
|
BANNER_ENROLLMENT | Yes |
| 15 Minutes | |
BANNER_MEETING | No | Distinct Clause in Query, SSRMEET has no primary key | 1 Day |