You are viewing a plain text version of this content. The canonical link for it is here.

Posted to derby-dev@db.apache.org by "Harshvardhan Gupta (JIRA)" <ji...@apache.org> on 2017/07/01 17:30:00 UTC

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

    [ https://issues.apache.org/jira/browse/DERBY-6942?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16071337#comment-16071337 ] 

Harshvardhan Gupta commented on DERBY-6942:
-------------------------------------------

In code, I am trying to query the statistics of those column which are backed by indexes. (and thus their statistics exist). 

I'm struck on this problem: How do we take a predicate and find out the relevant conglomerate from the list of all conglomerates associated with that table. From a predicate we can find out the ColumnReference which holds the Column Name, so I am trying to use this info to find out the relevant info. I would appreciate help on this blocker.

> Utilise additional statistics for selectivity estimates.
> --------------------------------------------------------
>
>                 Key: DERBY-6942
>                 URL: https://issues.apache.org/jira/browse/DERBY-6942
>             Project: Derby
>          Issue Type: Sub-task
>          Components: SQL
>            Reporter: Harshvardhan Gupta
>            Assignee: Harshvardhan Gupta
>            Priority: Minor
>         Attachments: z12.txt
>
>




--
This message was sent by Atlassian JIRA
(v6.4.14#64029)