what is optimizer statistics in Oracle?# Database - 数据库
h*r
1 楼
what is optimizer statistics and how to write script to generate it?Thanks
d*e
2 楼
sth like " update statistics"
【在 h****r 的大作中提到】
: what is optimizer statistics and how to write script to generate it?Thanks
【在 h****r 的大作中提到】
: what is optimizer statistics and how to write script to generate it?Thanks
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
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
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;
gathering and generating.
【在 x***u 的大作中提到】
: ANALYZE ...
: Or
: Hints like this
: SELECT /*+ ALL_ROWS */ empno, ename, sal, job
: FROM emp
: WHERE empno = 7566;
相关阅读
How to Import a Datatable as fast as possible?怎样解决 Index for NULL value我找工作，如果有空缺请说一下。你们等几天再出sql server题呀！how to check the definition of a stored procedure in TOAD请推荐一本自学SQL的书吧 sql server 面试题 （2）how to view blob data in toad? 为版上做包子，特来灌水发书Cheat sheet for Zenny's interview questionssql server 面试题 （6）请教比较两个table，找出相同和不同的records 再问个 subquery的问题老中都在高sql server？which one is the default?能不能检查某一条record什么时候写进DATABASE的?Re: 整个Joe the plumber事件最好笑的是 sql server 面试题 （5）sql server 面试题 （1）anyone has experience with VM + solaris/Linux + Oracle