----------------------------------------------------------------------------
-- 1、设置表并行查询
----------------------------------------------------------------------------
alter table tfa_alarm_clr_test parallel 1;
alter table tfa_alarm_clr_test parallel 8;
alter table tfa_alarm_clr_test noparallel;
select /*+parallel(a,8)*/ count(1) from tfa_alarm_clr_test a;
-- 表并行度degree
select t.table_name, t.degree
from user_tables t
where t.table_name = 'TFA_ALARM_CLR_TEST';
----------------------------------------------------------------------------
-- 2、设置表并行索引查询
----------------------------------------------------------------------------
alter index tfa_alarm_clr_test_1 parallel 1;
alter index tfa_alarm_clr_test_1 parallel 8;
alter index tfa_alarm_clr_test_1 noparallel;
select /*+parallel_index(a,8)*/count(1) from tfa_alarm_clr_test a;
select t.index_name, t.degree
from user_indexes t
where t.index_name = 'TFA_ALARM_CLR_TEST_1';
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/720091/viewspace-1057773/ ，如需转载，请注明出处，否则将追究法律责任。
