Oracle教程 2023-02-28

Oracle 视图 ALL_JOIN_IND_COLUMNS 官方解释，作用，如何使用详细说明

本站中文解释

Oracle视图ALL_JOIN_IND_COLUMNS用于显示归档用户下索引列示意图所用到的列。这些索引列可以用于联结。

使用方法：

1. 在历史库中执行查询SQL，查询ALL_JOIN_IND_COLUMNS视图表，获取归档用户下索引列示意图中参与联结的列：

SELECT *
FROM ALL_JOIN_IND_COLUMNS
WHERE OWNER = Schema_Name

2. 可以用示意图或工具来构建查询，然后运行，以联结查询所需的列。

例如：SELECT
Column_A, Column_B
FROM Table_X, Table_Y
WHERE Table_X.Column_A = Table_Y.Column_B;

官方英文解释

ALL_JOIN_IND_COLUMNS describes the join conditions of bitmap join indexes accessible to the current user. Bitmap join indexes are indexes built on a child table with an index key containing columns from associated parent tables, where all of the tables are connected through join conditions. There is one row for each join condition.

Related Views

DBA_JOIN_IND_COLUMNS describes all join conditions in the database.
USER_JOIN_IND_COLUMNS describes the join conditions owned by the current user. This view does not display the INDEX_OWNER column.

Column	Datatype	NULL	Description
`INDEX_OWNER`	`VARCHAR2(128)`	`NOT NULL`	Owner of the bitmap join index
`INDEX_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the bitmap join index
`INNER_TABLE_OWNER`	`VARCHAR2(128)`	`NOT NULL`	Owner of the fact table
`INNER_TABLE_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the fact table
`INNER_TABLE_COLUMN`	`VARCHAR2(128)`	`NOT NULL`	Name of the fact table join column
`OUTER_TABLE_OWNER`	`VARCHAR2(128)`	`NOT NULL`	Owner of the dimension table
`OUTER_TABLE_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the dimension table
`OUTER_TABLE_COLUMN`	`VARCHAR2(128)`	`NOT NULL`	Name of the dimension table join column

本站中文解释

官方英文解释

相关推荐