[ https://issues.apache.org/jira/browse/TRAFODION-1468?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14718570#comment-14718570 ]
Qifan Chen commented on TRAFODION-1468: --------------------------------------- Did some investigation with the actual query through OSIM and found the problem is with high estimated # of probes: disjunctNumLeadingPartPreds_ =0 disjunctFailedProbes_ = 0 disjunctOptRows_ = 1285 disjunctOptRqsts_ = 74731900 <== high disjunctOptProbesForSubsetBoundaries_ = 56606816 <== high disjunctOptSeeks_ = 26 disjunctOptSeqKBRead_ = 93781248 > MDAM plan is not chosen > ------------------------ > > Key: TRAFODION-1468 > URL: https://issues.apache.org/jira/browse/TRAFODION-1468 > Project: Apache Trafodion > Issue Type: Bug > Components: sql-cmp > Reporter: Qifan Chen > Assignee: Qifan Chen > Labels: performance > > The query is as follows. > select "cliente_CIC", "tipoMovimiento", sum("monto") from T where > ("cliente_CIC" = '000003566661') and "fechaOrigen" between cast('2013-12-01' > as timestamp(6)) and cast('2013-12-31' as timestamp(6)) group by 1, 2 order > by 1, 2; > Part of the DDL looks like: > create table T > (... ... > , PRIMARY KEY > ( > "cliente_CIC" > , "operacion_identificacionOperacion" > , "fechaOrigen" > , "nemonico" > , "claveUnicaRegistroJNL" > ) > ) > SALT USING 16 PARTITIONS ON > ( > "cliente_CIC" > , "operacion_identificacionOperacion" > ) > DIVISION BY > ( > date_part('YEARMONTH', "fechaOrigen") > ) > And stats are available for all leading key column groups. -- This message was sent by Atlassian JIRA (v6.3.4#6332)