My Oracle Support Banner

Slow Create/Refresh of Materialized View Based on NOT IN Definition Query (Doc ID 1591851.1)

Last updated on AUGUST 13, 2014

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.1 and later
Information in this document applies to any platform.

Symptoms

SCOTT@dw23>  CREATE MATERIALIZED VIEW t1mview1 AS
  2      SELECT *
  3      FROM t1
  4      WHERE t1.c1 NOT IN (SELECT c1 from t2);

Materialized view created.

Elapsed: 00:07:03.10

SCOTT@dw23>  CREATE table t1mview1_ct AS
  2      SELECT *
  3      FROM t1
  4      WHERE t1.c1 NOT IN (SELECT c1 from t2);

Table created.

Elapsed: 00:00:30.39

 

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.