asterixdb-notifications mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Till (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (ASTERIXDB-1779) Processing the certain function predicates after a simple predicates
Date Wed, 01 Feb 2017 16:39:51 GMT

    [ https://issues.apache.org/jira/browse/ASTERIXDB-1779?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15848597#comment-15848597
] 

Till commented on ASTERIXDB-1779:
---------------------------------

I think that the and-evaluator stops evaluating after getting the first "false". If so, the
predicates are ordered by increasing evaluation cost, this should already happen.
Do you see an issue with the example query?

> Processing the certain function predicates after a simple predicates
> --------------------------------------------------------------------
>
>                 Key: ASTERIXDB-1779
>                 URL: https://issues.apache.org/jira/browse/ASTERIXDB-1779
>             Project: Apache AsterixDB
>          Issue Type: Improvement
>            Reporter: Taewoo Kim
>
> For example, if we have the following AQL query,
> {code}
> for $i in dataset MyData
>    where $i.id < 5 and edit-distance($i.name, "Arnold") < 2
>    return $i;
> {code}
> It may be better to process *$i.id < 5* predicate first and then process *edit-distance($i.name,
"Arnold")* predicate since the processing cost of the latter is higher than that of the former.
 



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)

Mime
View raw message