[ 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)