ITPub博客

首页 > Linux操作系统 > Linux操作系统 > Viewing Index Information

Viewing Index Information

原创 Linux操作系统 作者:v_fantasy 时间:2009-01-11 16:09:57 0 删除 编辑

The following views display information about indexes:

View Description

DBA_INDEXES

ALL_INDEXES

USER_INDEXES

DBA view describes indexes on all tables in the database. ALL view describes indexes on all tables accessible to the user. USER view is restricted to indexes owned by the user. Some columns in these views contain statistics that are generated by the DBMS_STATS package or ANALYZE statement.

DBA_IND_COLUMNS

ALL_IND_COLUMNS

USER_IND_COLUMNS

These views describe the columns of indexes on tables. Some columns in these views contain statistics that are generated by the DBMS_STATS package or ANALYZE statement.

DBA_IND_EXPRESSIONS

ALL_IND_EXPRESSIONS

USER_IND_EXPRESSIONS

These views describe the expressions of function-based indexes on tables.

INDEX_STATS

Stores information from the last ANALYZE INDEX ... VALIDATE STRUCTURE statement.

INDEX_HISTOGRAM

Stores information from the last ANALYZE INDEX ... VALIDATE STRUCTURE statement.

V$OBJECT_USAGE

Contains index usage information produced by the ALTER INDEX ... MONITORING USAGE functionality.

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/16158219/viewspace-536365/,如需转载,请注明出处,否则将追究法律责任。

下一篇: 字符集总结
请登录后发表评论 登录
全部评论

注册时间:2008-10-07

  • 博文量
    98
  • 访问量
    181968