You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@asterixdb.apache.org by "Taewoo Kim (JIRA)" <ji...@apache.org> on 2017/02/01 06:14:51 UTC
[jira] [Updated] (ASTERIXDB-1779) Processing the certain function
predicates after a simple predicates
[ https://issues.apache.org/jira/browse/ASTERIXDB-1779?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Taewoo Kim updated ASTERIXDB-1779:
----------------------------------
Description:
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.
was:
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 the former.
> 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)