asterixdb-notifications mailing list archives

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

     [ 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)

Mime
View raw message