optimizer trace 文件中的名词缩写

CBQT costbased query transformationJPPD join predicate pushdownOJPPD oldstyle (noncostbased) JPPDFPD filter pushdownPM predicate movearoundCVM complex view mergingSPJ selectprojectjoinSJC set join conversionSU subquery unnestingOBYE order by eliminationOST old style star transformationST new (cbqt) star transformationCNT count(col) to count(*) transformationJE Join EliminationJF join factorizationSLP select list pruningDP distinct placementqb         query blockLB leaf blocksDK distinct keysLB/K average number of leaf blocks per keyDB/K average number of data blocks per keyCLUF clustering factorNDV number of distinct valuesResp response costCard cardinalityResc resource costNL nested loops (join)SM sort merge (join)HA hash (join)CPUSPEED CPU Speed IOTFRSPEED         I/O transfer speedIOSEEKTIM I/O seek timeSREADTIM average single block read timeMREADTIM average multiblock read timeMBRC average multiblock read countMAXTHR         maximum I/O system throughputSLAVETHR average slave I/O throughputdmeth distribution method1: no partitioning required2: value partitioned4: right is random (roundrobin)128: left is random (roundrobin)8: broadcast right and partition left16: broadcast left and partition right32: partition left using partitioning of right64: partition right using partitioning of left256: run the join in serial0: invalid distribution methodsel selectivityptn partition

1楼hncsy403昨天 20:14

学习了