|
The materialized view mv_feed_stats is updated in nightly maintenance, but on startup when it does not exist yet, v_feeds_snr is defined to calculate the long way by running a full table scan on fm_items. Rebuilding the materialized view is no slower, so we might as well do it on demand when a query calling v_feeds_snr is executed and mv_feeds_stats does not exist yet.
|
Type: new Version: Status: new Created: 2009-Oct-29 03:13 Severity: 1 Last Change: 2009-Oct-29 03:13 Priority: 1 Subsystem: Assigned To: majid Derived From: Creator: majid