Redian新闻
>
what is optimizer statistics in Oracle?
avatar
what is optimizer statistics in Oracle?# Database - 数据库
h*r
1
what is optimizer statistics and how to write script to generate it?Thanks
avatar
d*e
2
sth like " update statistics"

【在 h****r 的大作中提到】
: what is optimizer statistics and how to write script to generate it?Thanks
avatar
x*u
3
ANALYZE ...
Or
Hints like this
SELECT /*+ ALL_ROWS */ empno, ename, sal, job
FROM emp
WHERE empno = 7566;

【在 h****r 的大作中提到】
: what is optimizer statistics and how to write script to generate it?Thanks
avatar
a*c
4
If you are in Oracle, you can use DBMS_STATS package for optimizer statistics
gathering and generating.

【在 x***u 的大作中提到】
: ANALYZE ...
: Or
: Hints like this
: SELECT /*+ ALL_ROWS */ empno, ename, sal, job
: FROM emp
: WHERE empno = 7566;

相关阅读
logo
联系我们隐私协议©2024 redian.news
Redian新闻
Redian.news刊载任何文章,不代表同意其说法或描述,仅为提供更多信息,也不构成任何建议。文章信息的合法性及真实性由其作者负责,与Redian.news及其运营公司无关。欢迎投稿,如发现稿件侵权,或作者不愿在本网发表文章,请版权拥有者通知本网处理。