oracle first_rows怎么用,Oracle执行计划——all_rows和first_rows(n) 优化器模式

0. 环境创建

SQL> create usertest identified by test

2 default tablespace users

3 temporary tablespace temp

4 quota unlimited on users;

User created.

SQL> grant createsession, resource, alter session to test;

Grant succeeded.

SQL> conntest/test;

Connected.

SQL> create tableemp(id number, name varchar2(10));

Table created.

SQL> insert intoemp values(100, 'tom');

1 row created.

SQL> insert intoemp values(200, 'mike');

1 row created.

SQL> insert intoemp values(300, 'jack');

1 row created.

SQL> insert intoemp values(400, 'rose');

1 row created.

SQL> commit;

Commit complete.

1. 数据少时的情况

1.1 FIRST_ROWS_10

SQL> setautotrace traceonly;

SQL> executedbms_stats.gather_table_stats(