[jira] [Updated] (TRAFODION-41) Update statistics utility is too conservative in allowing in-memory sort operating mode

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

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

Suresh Subbiah updated TRAFODION-41:
------------------------------------
    Component/s: sql-cmp

> Update statistics utility is too conservative in allowing in-memory sort operating mode
> ---------------------------------------------------------------------------------------
>
>                 Key: TRAFODION-41
>                 URL: https://issues.apache.org/jira/browse/TRAFODION-41
>             Project: Apache Trafodion
>          Issue Type: Bug
>          Components: sql-cmp
>            Reporter: Qifan Chen
>            Assignee: Qifan Chen
>
> The update statistics is very conservative in use of  in-memory sort to create stats.  Currently, in memory mode is enabled only if no multi-column stats is requested. Under the default operation, 820MB memory is available for in-memory sort and can be more than adequate to build the multi-column stats in memory. 
> As a consequence, the utility will use a sample table to hold the sampled rows., which can be avoided with in-memory sort. 



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