刷新物化视图很慢_物化视图增量刷新显示刷新成功，但数据没刷过来 - 墨天轮问答...

CREATE MATERIALIZED VIEW “T_DT_INVENTORY_MV” (“ID”, “LAST_UPDATE_DATE”, “ABLESALEQUANTITY”)

SEGMENT CREATION IMMEDIATE

ORGANIZATION HEAP PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255

NOCOMPRESS LOGGING

STORAGE(INITIAL 163840 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645

PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1

BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)

TABLESPACE “BIODSD”

BUILD IMMEDIATE

USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255

STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645

PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1

BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)

TABLESPACE “BIODSD”

REFRESH FAST ON DEMAND

WITH ROWID USING DEFAULT LOCAL ROLLBACK SEGMENT

USING ENFORCED CONSTRAINTS DISABLE ON QUERY COMPUTATION DISABLE QUERY REWRITE

AS SELECT

“T_DT_INVENTORY”.“ID” “ID”

,“T_DT_INVENTORY”.“LAST_UPDATE_DATE” “LAST_UPDATE_DATE”

,“T_DT_INVENTORY”.“ABLESALEQUANTITY” “ABLESALEQUANTITY”

FROM “JYMASB”.“T_API_INVENTORY”@BI_JXCB