ignite-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Denis Magda (JIRA)" <j...@apache.org>
Subject [jira] [Created] (IGNITE-4524) Indexes usage in SQL functions like min/max
Date Wed, 04 Jan 2017 18:19:58 GMT
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)

Mime
View raw message