[
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)
