Oracle使用hash分区优化分析函数查询

复制create table t_partition_hash( object_name varchar2(128),使用 subobject_name varchar2(30), object_id number, data_object_id number, object_type varchar2(19), created date, last_ddl_time date, timestamp varchar2(19), status varchar2(7), temporary varchar2(1), generated varchar2(1), secondary varchar2(1) )  partition by hash(object_type)(  partition t_hash_p1 tablespace USERS,  partition t_hash_p2 tablespace USERS,  partition t_hash_p3 tablespace USERS,  partition t_hash_p4 tablespace USERS,  partition t_hash_p5 tablespace USERS,  partition t_hash_p6 tablespace USERS,  partition t_hash_p7 tablespace USERS,  partition t_hash_p8 tablespace USERS  );

create table t_big_hash( object_name varchar2(128), subobject_name varchar2(30), object_id number, data_object_id number, object_type varchar2(19), created date, last_ddl_time date, timestamp varchar2(19), status varchar2(7), temporary varchar2(1), generated varchar2(1), secondary varchar2(1) );1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.18.19.20.21.22.23.24.25.26.27.28.29.30.31.32.33.34.35.36.37.38.39.40.41.42.

本文地址：http://www.bzve.cn/news/366f1999614.html