【翻译自mos文章】OGG支持oracle db 11g中的不可见索引吗？

最新推荐文章于 2025-07-16 14:40:20 发布

翻译最新推荐文章于 2025-07-16 14:40:20 发布 · 1.6k 阅读

Oracle DB 同时被 2 个专栏收录

772 篇文章

订阅专栏

Oracle GoldenGate

28 篇文章

订阅专栏

本文介绍Oracle GoldenGate (OGG) 在11.2.1.0.5及更高版本中支持Oracle 11g数据库的隐形索引功能。隐形索引允许用户选择是否将索引暴露给优化器，这有助于生成更高效的SQL执行计划。早期版本的OGG不支持此特性，如果表上仅定义了隐形唯一索引，OGG会忽略该索引的存在。

来源于：

Does OGG support Invisible Indexes in Oracle 11g db (文档 ID 1515952.1)

APPLIES TO:

Oracle GoldenGate - Version 11.2.1.0.1 and later
Information in this document applies to any platform.

GOAL

A new feature in Oracle 11g allows the creation of "invisible" indexes which means they are indexes

that we can choose when to expose to the optimizer when generating SQL plans. Current versions

of OGG do not support invisible indexes. So if only an invisible unique index is defined on a table,

OGG chooses not to see the unique index and treats this table as not having any unique index defined.

FIX

It is supported in OGG version 11.2.1.0.5 and higher. Support was added in following bug fix.

Bug 14099231 - SUPPORT ORACLE INVISIBLE INDEXES

The fix can be backported if needed. There is also a work-around of using KEYCOLS to force the

selection of invisible index columns.