[jira] [Created] (IGNITE-4524) Indexes usage in SQL functions like min/max

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

[jira] [Created] (IGNITE-4524) Indexes usage in SQL functions like min/max

Anton Vinogradov (Jira)
Denis Magda created IGNITE-4524:
-----------------------------------

             Summary: Indexes usage in SQL functions like min/max
                 Key: IGNITE-4524
                 URL: https://issues.apache.org/jira/browse/IGNITE-4524
             Project: Ignite
          Issue Type: Bug
            Reporter: Denis Magda


If to execute queries like this

{code}
select min(id) from MyValue
select max(id) from MyValue
{code}

assuming that 'id' is an indexed field then the engine will not gain from this.

The SQL engine needs to be improved so that the indexes are used for queries like the ones above.

More details can be found in this discussion:
http://apache-ignite-developers.2346864.n4.nabble.com/min-max-SQL-and-indexes-td13492.html



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)