[
https://issues.apache.org/jira/browse/DERBY-6942?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16082789#comment-16082789
]
Harshvardhan Gupta edited comment on DERBY-6942 at 7/11/17 7:16 PM:
--------------------------------------------------------------------
During the local tests I did, I tested the selectivity outputs for relational
operators of the following types : (>=, <=, > , <) and integer data type with
the latest patch.
Regarding the examples Bryan mentioned, I am not quite sure about this but I
believe 'between' operator is internally transformed into one of these
relational ops, in that case the latest patch is good for 'between' op also.
UPDATE: between transformation seem to work with the patch and the selectivity
is the product of individual selectivities of LESS_THAN and GREATER_THAN
operator types.
was (Author: harshvardhan145):
During the local tests I did, I tested the selectivity outputs for relational
operators of the following types : (>=, <=, > , <) and integer data type with
the latest patch.
Regarding the examples Bryan mentioned, I am not quite sure about this but I
believe 'between' operator is internally transformed into one of these
relational ops, in that case the latest patch is good for 'between' op also.
> 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: DERBY-6942_2.diff, DERBY-6942.diff, z12.txt, z13.txt
>
>
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)