跟着官方文档学HINT（-）测试表准备

测试表我选择了比较有名的两张表

scott.emp

scott.dept 

dba_objects 

这些表都是大常见的 大家对其结构也很了解。

SQL> create table dao_object1 as select * from dba_objects Table created.SQL> create table dao_object2 as select * from dba_objects ;SQL> create index idx_dao_obj1  on dao_object1 (object_Id) ;Index created.SQL> create table emp as select * from scott.emp ;Table created.SQL> create table dept as select * from scott.dept ;Table created.SQL> create index idx_dao_obj2 on dao_object1 (object_name) ;  Index created.