Re: [jira] [Commented] (DERBY-6942) Utilise additional statistics for selectivity estimates.

2017-08-27 Thread Bryan Pendleton
Perhaps you could open the appropriate JIRA issues (to add documentation; to add additional data types; etc.) as sub-tasks of this JIRA issue, to help us keep track of it all?

[jira] [Commented] (DERBY-6942) Utilise additional statistics for selectivity estimates.

2017-08-26 Thread Bryan Pendleton (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-6942?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16142950#comment-16142950 ] Bryan Pendleton commented on DERBY-6942: I think it would be fine to add additional data types

[jira] [Commented] (DERBY-6942) Utilise additional statistics for selectivity estimates.

2017-08-25 Thread Harshvardhan Gupta (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-6942?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16141740#comment-16141740 ] Harshvardhan Gupta commented on DERBY-6942: --- Bryan, I am summarizing the remaining work

[jira] [Commented] (DERBY-6942) Utilise additional statistics for selectivity estimates.

2017-07-15 Thread Bryan Pendleton (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-6942?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16088698#comment-16088698 ] Bryan Pendleton commented on DERBY-6942: Can you attach any of the output of your testing? For

[jira] [Commented] (DERBY-6942) Utilise additional statistics for selectivity estimates.

2017-07-11 Thread Harshvardhan Gupta (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-6942?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16082789#comment-16082789 ] Harshvardhan Gupta commented on DERBY-6942: --- During the local tests I did, I tested the

[jira] [Commented] (DERBY-6942) Utilise additional statistics for selectivity estimates.

2017-07-08 Thread Bryan Pendleton (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-6942?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16079341#comment-16079341 ] Bryan Pendleton commented on DERBY-6942: This seems like a reasonable approach to me. As I'm

[jira] [Commented] (DERBY-6942) Utilise additional statistics for selectivity estimates.

2017-07-08 Thread Harshvardhan Gupta (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-6942?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16079256#comment-16079256 ] Harshvardhan Gupta commented on DERBY-6942: --- I experimented with integrating max and min values

[jira] [Commented] (DERBY-6942) Utilise additional statistics for selectivity estimates.

2017-07-01 Thread Harshvardhan Gupta (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-6942?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16071413#comment-16071413 ] Harshvardhan Gupta commented on DERBY-6942: --- Yes, the cardinality and cost estimates are both

[jira] [Commented] (DERBY-6942) Utilise additional statistics for selectivity estimates.

2017-07-01 Thread Bryan Pendleton (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-6942?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16071408#comment-16071408 ] Bryan Pendleton commented on DERBY-6942: Let me see if I get that, too: the cost of the table scan

[jira] [Commented] (DERBY-6942) Utilise additional statistics for selectivity estimates.

2017-07-01 Thread Harshvardhan Gupta (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-6942?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16071405#comment-16071405 ] Harshvardhan Gupta commented on DERBY-6942: --- Let me emphasize on this improvement in case of

[jira] [Commented] (DERBY-6942) Utilise additional statistics for selectivity estimates.

2017-07-01 Thread Harshvardhan Gupta (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-6942?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16071404#comment-16071404 ] Harshvardhan Gupta commented on DERBY-6942: --- Bryan, You are on point! > Utilise additional

[jira] [Commented] (DERBY-6942) Utilise additional statistics for selectivity estimates.

2017-07-01 Thread Bryan Pendleton (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-6942?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16071403#comment-16071403 ] Bryan Pendleton commented on DERBY-6942: Let me see if I understand your conclusions so far:

[jira] [Commented] (DERBY-6942) Utilise additional statistics for selectivity estimates.

2017-07-01 Thread Harshvardhan Gupta (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-6942?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16071337#comment-16071337 ] Harshvardhan Gupta commented on DERBY-6942: --- In code, I am trying to query the statistics of

[jira] [Commented] (DERBY-6942) Utilise additional statistics for selectivity estimates.

2017-06-28 Thread Harshvardhan Gupta (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-6942?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16067124#comment-16067124 ] Harshvardhan Gupta commented on DERBY-6942: --- In particular, when estimating cost for a

[jira] [Commented] (DERBY-6942) Utilise additional statistics for selectivity estimates.

2017-06-28 Thread Harshvardhan Gupta (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-6942?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16067117#comment-16067117 ] Harshvardhan Gupta commented on DERBY-6942: --- The example I discussed above was quite a simple

[jira] [Commented] (DERBY-6942) Utilise additional statistics for selectivity estimates.

2017-06-28 Thread Harshvardhan Gupta (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-6942?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16067113#comment-16067113 ] Harshvardhan Gupta commented on DERBY-6942: --- The estimateCost function in FromBaseTable.java is