[jira] [Created] (IGNITE-10781) Add supportion findNext for H2TreeIndex to use H2 optimization for DISTINCT

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

[jira] [Created] (IGNITE-10781) Add supportion findNext for H2TreeIndex to use H2 optimization for DISTINCT

Anton Vinogradov (Jira)
Taras Ledkov created IGNITE-10781:
-------------------------------------

             Summary: Add supportion findNext for H2TreeIndex to use H2 optimization for DISTINCT
                 Key: IGNITE-10781
                 URL: https://issues.apache.org/jira/browse/IGNITE-10781
             Project: Ignite
          Issue Type: Improvement
          Components: sql
    Affects Versions: 2.7
            Reporter: Taras Ledkov


Now {{H2TreeIndex}} doesn't implement the method {{BaseIndex#findNext}}.

This method is used by H2 engine in the [optimization of the DISTINCT|https://www.h2database.com/javadoc/org/h2/engine/DbSettings.html#OPTIMIZE_DISTINCT].

To enable this optimization we have to implement the *findNext* method.
Also we have provide selectivity info for the distinct column, because the optimization is enabled only when column selectivity < 0,2 (and column selectivity isn't default).



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)