Oracle 分区表 收集统计信息 参数granularity
GRANULARITY
Determines the granularity of statistics to collect. This value is only relevant for partitioned tables.
参数可选项：
GRANULARITY - The value determines granularity of statistics to collect (only pertinent if the table is partitioned).
'ALL' - gathers all (subpartition, partition, and global) statistics
'AUTO'- determines the granularity based on the partitioning type. This is the default value.
'DEFAULT' - gathers global and partition-level statistics. This option is obsolete, and while currently supported, it is included in the documentation for legacy reasons only. You should use the 'GLOBAL AND PARTITION' for this functionality. Note that the default value is now 'AUTO'.
'GLOBAL' - gathers global statistics
'GLOBAL AND PARTITION' - gathers the global and partition level statistics. No subpartition level statistics are gathered even if it is a composite partitioned object.
'PARTITION '- gathers partition-level statistics
'SUBPARTITION' - gathers subpartition-level statistics.
exec DBMS_STATS.GATHER_TABLE_STATS(ownname=>'H5YYT',tabname=>'TL_EC_H5_SERVICE_LOG',partname=>'TL_EC_H5_SERVICE_LOG_201809',granularity=>'ALL',estimate_percent=>10,no_invalidate=>false,cascade=>true,degree =>10);
最新文章
- 头显HTC Vive北美直降100美元，中国区降价活动今日公布
- 6个重要的.NET概念:栈,堆,值类型,引用类型,装箱,拆箱
- web
- 解决 webx.ml 中The superclass "javax.servlet.http.HttpServlet" was not found on the Java Build Path 问题
- ListView 总结----持续中
- JS获取select的值
- 网络安全之IP伪造
- C#版的抓包软件
- 最佳新秀Java（22）——再次了解泛型
- zabbix入门知识
- A*寻路算法入门(三)
- angular-nvd3初体验
- C. Neko does Maths(数论 二进制枚举因数)
- 移动端IOS 固定下方的输入框，点击输入框位置会变的修复
- python的特殊方法介绍
- ctrl+E 快速显示当前打开的编辑列表
- Foxmail邮箱最新应用指南 --如何使用「邮件标签」？
- CSS3入门学习之属性大全手册
- java后台代码发送邮件
- 解决spark中遇到的数据倾斜问题