Oracle 视图 ALL_ANALYTIC_VIEW_HIER_CLS_AE 官方解释，作用，如何使用详细说明
本站中文解释
ALL_ANALYTIC_VIEW_HIER_CLS_AE是Oracle 12c中的一个特殊的视图，用于封装优化数据网格层次结构准备的活动层级和父子表，使他们可以以正确的方式被查询。它与从ALL_ANALYTIC_VIEW_HIER_CLS中解析出来的表结构相同，包括优化表、索引、和外键。
其用途在于维护数据网格的正确性，通过它可以访问特定活动层级的层级和子表的元数据信息，这些元数据将使查询更300彩票官2019网站方便、更高效。
你可以通过运行SELECT * FROM ALL_ANALYTIC_VIEW_HIER_CLS_AE 的语句来使用这个视图。这个语句将查询出活动索引和索引细节。可以使用这个信息来检查高效索引是否存在，或者检查激活层次结构是否已编制完毕。这个视图还可以用来检查索引被激活前层次结构中的行数，或者查看父子表的信息。
官方英文解释
ALL_ANALYTIC_VIEW_HIER_CLS_AE describes the classifications of the hierarchies in the analytic views (across all editions) accessible to the current user.
Related Views
-
DBA_ANALYTIC_VIEW_HIER_CLS_AEdescribes the classifications of the hierarchies in all analytic views (across all editions) in the database. -
USER_ANALYTIC_VIEW_HIER_CLS_AEdescribes the classifications of the hierarchies in the analytic views (across all editions) owned by the current user. This view does not display theOWNERcolumn.
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
|
Owner of the hierarchy |
|
|
|
|
Name of the analytic view |
|
|
|
Alias of the attribute dimension in the analytic view |
|
|
|
|
Alias of the hierarchy in the attribute dimension in the analytic view |
|
|
|
|
Classification associated with the hierarchy |
|
|
|
|
Value of the classification, or NULL if not specified |
|
|
|
|
|
|
|
|
|
|
Order of the classification in the list of classifications associated with the hierarchy |
|
|
|
The ID of the container where the data originates. Possible values include:
|
|
|
|
|
Name of the application edition where the analytic view is defined |
Note:
This view is available starting with Oracle Database release 21c, version 21.5.
See Also:
-
“DBA_ANALYTIC_VIEW_HIER_CLS_AE”
-
“USER_ANALYTIC_VIEW_HIER_CLS_AE”
