[jira] [Updated] (TRAFODION-834) LP Bug: 1403953 - full scan indicator in the CompilerStatsInfo is not set

["Suresh Subbiah (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/TRAFODION-834?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Suresh Subbiah updated TRAFODION-834:
-------------------------------------
    Assignee: Qifan Chen  (was: Ravisha Neelakanthappa)

> LP Bug: 1403953 - full scan indicator in the CompilerStatsInfo is not set
> -------------------------------------------------------------------------
>
>                 Key: TRAFODION-834
>                 URL: https://issues.apache.org/jira/browse/TRAFODION-834
>             Project: Apache Trafodion
>          Issue Type: Bug
>          Components: sql-cmp
>            Reporter: Qifan Chen
>            Assignee: Qifan Chen
>
> In traf, the full scan indicator in the CompilerStatsInfo is not set. On Seaquest we set this in FileScan::preCodeGen(). 
> From Arvind:
> The select you did should result in a full scan. CCg Mike and Selva to confirm if the flag gets set in Trafodion and whether we should be looking at that in INFOSTATS. We get this compile stat info as an output from SQL_EXEC_Prepare2() and the same is displayed via INFOSTATS
> Since ‘cs’ option is not returning the compile stats debugged sqlci - 
> (gdb) p *cmpStatsInfo
> $8 = {totalOps_ = 2, exchangeOps_ = 0, dp2Ops_ = 0, hj_ = 0, mj_ = 0, nj_ = 0, 
>   espTotal_ = 0, espLevels_ = 0, dop_ = 0, collectStatsType_ = 5, 
>   affinityNumber_ = 0, totalFragmentSize_ = 16, masterFragmentSize_ = 16, 
>   espFragmentSize_ = 0, dp2FragmentSize_ = 0, dp2RowsAccessed_ = 0, 
>   dp2RowsUsed_ = 0, dp2RowsAccessedForFullScan_ = -1, flags_ = 0, bmo_ = 0, 
>   udr_ = 0, ofSize_ = 0, ofMode_ = 2, queryType_ = 2, subqueryType_ = 0, 
>   filler_ = '\000' <repeats 47 times>}
> Regards
> Arvind
> =======================  how to verify 
> SQL>PREPARE S1 from select * from TRAFODION."_REPOS_".METRIC_QUERY_TABLE;
> --- SQL command prepared.
> SQL>INFOSTATS S1;
> QueryID         CPUTime     IOTime    MsgTime     IdleTime TotalTime Cardinality ResourceUsage AffinityNumber Dop  XnNeeded MandatoryCrossProduct MissingStats NumOfJoins FullScanOnTable HighDp2MxBufferUsage RowsAccessedForFullScan Dp2RowsAccessed Dp2RowsUsed
> ------------------------------------------------------------ ----------- --------- ----------- -------- --------- ----------- ------------- -------------- ---- -------- --------------------- ------------ ---------- --------------- -------------------- ----------------------- --------------- -----------
> MXID11000024022212285042097397025000000000406U3333300_237_S1  0.00521141  0.544427  0.00372297        0  0.553361         319             0              0    0        0         0            0          0               0              0            -1               0           0
> --- SQL operation complete.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)