当前位置：首页 > news >正文

并行 parallel broadcast partition pruning 分区裁剪 optimizer_dynamic_sampling=7

news 2025/7/6 3:34:16

insert into abc 没有PDML所以不是全部并行

只有select 的情况全部并行，没有 px send broadcast ，所以rows没从103M变成103*8M

select *from A，B where A.Pkey = B.Pkey and A.Pkey = 'XX'

A B表都会进行分区裁剪

----并行为什么更准确，因为用了OPT_PARAM('optimizer_dynamic_sampling' 7)

BEGIN_OUTLINE_DATA
IGNORE_OPTIM_EMBEDDED_HINTS
OPTIMIZER_FEATURES_ENABLE('19.1.0')
DB_VERSION('19.1.0')
OPT_PARAM('optimizer_dynamic_sampling' 7)
ALL_ROWS
OUTLINE_LEAF(@"SEL$58A6D7F6")
MERGE(@"SEL$1" >"SEL$2")
OUTLINE_LEAF(@"INS$1")
OUTLINE(@"SEL$2")
OUTLINE(@"SEL$1")
FULL(@"INS$1" "ABC"@"INS$1")
FULL(@"SEL$58A6D7F6" "TH"@"SEL$1")
FULL(@"SEL$58A6D7F6" "TSA"@"SEL$1")
LEADING(@"SEL$58A6D7F6" "TH"@"SEL$1" "TSA"@"SEL$1")
USE_HASH(@"SEL$58A6D7F6" "TSA"@"SEL$1")
PQ_DISTRIBUTE(@"SEL$58A6D7F6" "TSA"@"SEL$1" BROADCAST NONE)
END_OUTLINE_DATA