h****r
发帖数: 2056 | 1 what is optimizer statistics and how to write script to generate it?Thanks | d******e
发帖数: 2265 | 2 sth like " update statistics"
【在 h****r 的大作中提到】
: what is optimizer statistics and how to write script to generate it?Thanks
| x***u
发帖数: 9 | 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
| a****c
发帖数: 25 | 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;
|
|
