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

Posted to dev@ignite.apache.org by "Denis Magda (JIRA)" <ji...@apache.org> on 2017/01/04 18:19:58 UTC

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

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)