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

["Qifan Chen (JIRA)" <ji...@apache.org>]

Qifan Chen created TRAFODION-41:
-----------------------------------

             Summary: 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
            Reporter: 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)