what is optimizer statistics in Oracle?# Database - 数据库h*r2002-03-11 08:031 楼what is optimizer statistics and how to write script to generate it?Thanks
d*e2002-03-11 08:032 楼sth like " update statistics"【在 h****r 的大作中提到】: what is optimizer statistics and how to write script to generate it?Thanks
x*u2002-03-11 08:033 楼ANALYZE ...OrHints like thisSELECT /*+ ALL_ROWS */ empno, ename, sal, jobFROM empWHERE empno = 7566;【在 h****r 的大作中提到】: what is optimizer statistics and how to write script to generate it?Thanks
a*c2002-03-11 08:034 楼If you are in Oracle, you can use DBMS_STATS package for optimizer statisticsgathering and generating.【在 x***u 的大作中提到】: ANALYZE ...: Or: Hints like this: SELECT /*+ ALL_ROWS */ empno, ename, sal, job: FROM emp: WHERE empno = 7566;