1-- 2-- PARALLEL 3-- 4 5begin; 6 7-- encourage use of parallel plans 8set parallel_setup_cost=0; 9set parallel_tuple_cost=0; 10set min_parallel_table_scan_size=0; 11set max_parallel_workers_per_gather=4; 12 13-- 14-- Test write operations that has an underlying query that is eligible 15-- for parallel plans 16-- 17explain (costs off) create table parallel_write as 18 select length(stringu1) from tenk1 group by length(stringu1); 19create table parallel_write as 20 select length(stringu1) from tenk1 group by length(stringu1); 21drop table parallel_write; 22 23explain (costs off) select length(stringu1) into parallel_write 24 from tenk1 group by length(stringu1); 25select length(stringu1) into parallel_write 26 from tenk1 group by length(stringu1); 27drop table parallel_write; 28 29explain (costs off) create materialized view parallel_mat_view as 30 select length(stringu1) from tenk1 group by length(stringu1); 31create materialized view parallel_mat_view as 32 select length(stringu1) from tenk1 group by length(stringu1); 33create unique index on parallel_mat_view(length); 34refresh materialized view parallel_mat_view; 35refresh materialized view concurrently parallel_mat_view; 36drop materialized view parallel_mat_view; 37 38prepare prep_stmt as select length(stringu1) from tenk1 group by length(stringu1); 39explain (costs off) create table parallel_write as execute prep_stmt; 40create table parallel_write as execute prep_stmt; 41drop table parallel_write; 42 43rollback; 44