Chapter 4: enable and disable im column storage for materialized view (IM 4.6)

In-Memory The manual : Preface （IM- Preface ）

Chapter one Oracle Database In-Memory Relevant concepts (IM-1.1)

Chapter one Oracle Database In-Memory Relevant concepts （ To continue ）(IM-1.2)

Chapter two Oracle Database In-Memory Architecture ( On ) (IM-2.1)

Chapter two In-Memory Architecture (IM-2.2)

Chapter two IM Architecture ：CPU framework ：SIMD Vector processing （IM-2.3）

The third chapter Enable and adjust IM The size of the column store （IM-3.1）

Chapter four by In-Memory Enable fill objects （IM-4.1 The first part ）

Chapter four by In-Memory Enable fill objects （IM-4.2 The second part ）

Chapter four by IM Enable and disable columns for fill objects （IM-4.3 The third part ）

Chapter four by IM Enables the placement of fill objects NO INMEMORY The table specifies INMEMORY Column properties ： Example （IM-4.4 The fourth part ）

Chapter four by IM Enable and disable tablespaces for padding objects IM Column store （IM 4.5） This article is IM Chapter 4 of the series ： Enable and disable... For materialized views IM Column store （IM-4.6）

Enable and disable... For materialized views IM Column store

You can enable and disable... For materialized views IM Column store .

By means of CREATEMATERIALIZED VIEW or ALTERMATERIALIZED VIEW The statement contains INMEMORY Clause , Enable... For materialized views IM Column store . By means of CREATEMATERIALIZED VIEW or ALTERMATERIALIZED VIEW The statement contains NO INMEMORY Clause to disable materialized views IM Column store .

To enable or disable... For materialized views IM Column storage requires the following steps ：

1. Ensure that... Is enabled for the database IM Column store .

Please see the “ Enable... For the database IM Column store ”.

2. Log in to the database as a user with permission to create or change materialized views .

3. Running has INMEMORY Clause or NO INMEMORY Clause CREATE MATERIALIZEDVIEW or ALTERMATERIALIZED VIEW sentence .

Example 4-14 Create a materialized view and enable IM Column store

The following statement creates oe.prod_info_mv Materialized view , And enable IM Column store ：

CREATE MATERIALIZED VIEW oe.prod_info_mv INMEMORY 

  AS SELECT * FROM oe.product_information;

This sample uses INMEMORY The default value of the clause ： MEMCOMPRESS FORQUERY LOW and PRIORITY NONE.

Example 4-15 Enable with for materialized views HIGH Priority of data filling IM Column store

The following statement is oe.prod_info_mv Materialized view enabled IM Column store ：

ALTER MATERIALIZED VIEW oe.prod_info_mv INMEMORY PRIORITY HIGH;

This example uses the default compression ：MEMCOMPRESS FORQUERY LOW.

Shandong Oracle User group (Shandong Oracle User Group), abbreviation ：SDOUG, Is a full of vitality 、 Young non-profit organizations , It aims to provide an exchange platform for technology lovers in Jinan and surrounding areas .SDOUG Organize offline technology sharing activities from time to time , Promote local and surrounding IT Technological development 、 Help technology enthusiasts improve themselves . Share technology 、 Share happiness ,SDOUG On the road .