View statistics in the data dictionary
来源:互联网 发布:mac ai如何剪切图片 编辑:程序博客网 时间:2024/04/30 03:39
To view statistics in the data dictionary, query the appropriate data dictionary view (USER_, ALL_, or DBA_). The following list shows the DBA_ views:
DBA_TABLES
DBA_TAB_COL_STATISTICS
DBA_INDEXES
DBA_CLUSTERS
DBA_TAB_PARTITIONS
DBA_TAB_SUBPARTITIONS
DBA_IND_PARTITIONS
DBA_IND_SUBPARTITIONS
DBA_PART_COL_STATISTICS
DBA_SUBPART_COL_STATISTICS
Viewing Histograms
To view histogram information, query the appropriate data dictionary view (USER_, ALL_, or DBA_). The following list shows the DBA_ views:
DBA_HISTOGRAMS
DBA_PART_HISTOGRAMS
DBA_SUBPART_HISTOGRAMS
DBA_TAB_COL_STATISTICS
Number of Rows
View the DBA_HISTOGRAMS dictionary table for the number of buckets (in other words, the number of rows) for each column:
ENDPOINT_NUMBER
ENDPOINT_VALUE
- View statistics in the data dictionary
- View Column Updatability Information from the Data Dictionary
- BC430-Unit2:Data Types in the ABAP Dictionary
- data dictionary and dynamic performance view
- SharePoint At Work----Hyperlinks in the Data View Web Part
- 15.View the Exhibit and examine the data in the CUSTOMERS table.
- 17.View the Exhibit and examine the data in the EMPLOYEES table.
- 53.View the Exhibit and examine the data in the PROMOTIONS table.
- 59.View the Exhibit and examine the data in the PRODUCTS table.
- 64.View the Exhibit and examine the data in the PROMO_CATEGORY and PROMO_COST columns of
- 66.View the Exhibit and examine the data in the COSTS table.
- 85.View the Exhibit and examine the structure and data in the INVOICE table.
- 97.View the Exhibit and evaluate the structure and data in the CUST_STATUS table.
- 107.View the Exhibit and examine the structure and data in the INVOICE table.
- 126.View the Exhibit and examine the data in the PROJ_TASK_DETAILS table.
- 130.View the Exhibit and examine the data in the EMPLOYEES table:
- 150.View the Exhibit and examine the data in the PROMOTIONS table.
- Modify the value of Dictionary in circle
- 数据库一致关闭后REDO LOG全部丢失的解决办法
- 转移统计信息
- 跳跃式索引(Skip Scan Index)的浅析(作者:fuyuncat)
- 走进自己的内心
- 关于Bind Variables Peeking
- View statistics in the data dictionary
- 关于同操作系统的32bit到64bit的数据库迁移参考文档
- rebuild和rebuild online的区别
- Some hint
- 一条SQL语句如何被解析
- 关于CURSOR_SHARING三个取值的区别
- Shared Pool的一点理解
- [用友]年度结转
- 能否再给爱一次机会