Return-Path: X-Original-To: archive-asf-public-internal@cust-asf2.ponee.io Delivered-To: archive-asf-public-internal@cust-asf2.ponee.io Received: from cust-asf.ponee.io (cust-asf.ponee.io [163.172.22.183]) by cust-asf2.ponee.io (Postfix) with ESMTP id 2FB61200C0E for ; Wed, 1 Feb 2017 17:39:55 +0100 (CET) Received: by cust-asf.ponee.io (Postfix) id 2E2BD160B46; Wed, 1 Feb 2017 16:39:55 +0000 (UTC) Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by cust-asf.ponee.io (Postfix) with SMTP id 78190160B41 for ; Wed, 1 Feb 2017 17:39:54 +0100 (CET) Received: (qmail 15290 invoked by uid 500); 1 Feb 2017 16:39:53 -0000 Mailing-List: contact notifications-help@asterixdb.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@asterixdb.apache.org Delivered-To: mailing list notifications@asterixdb.apache.org Received: (qmail 15277 invoked by uid 99); 1 Feb 2017 16:39:53 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd3-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 01 Feb 2017 16:39:53 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd3-us-west.apache.org (ASF Mail Server at spamd3-us-west.apache.org) with ESMTP id 52CCD180371 for ; Wed, 1 Feb 2017 16:39:53 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd3-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: -1.198 X-Spam-Level: X-Spam-Status: No, score=-1.198 tagged_above=-999 required=6.31 tests=[KAM_ASCII_DIVIDERS=0.8, KAM_LAZY_DOMAIN_SECURITY=1, RP_MATCHES_RCVD=-2.999, URIBL_BLOCKED=0.001] autolearn=disabled Received: from mx1-lw-us.apache.org ([10.40.0.8]) by localhost (spamd3-us-west.apache.org [10.40.0.10]) (amavisd-new, port 10024) with ESMTP id V_sBt9DNZEqO for ; Wed, 1 Feb 2017 16:39:52 +0000 (UTC) Received: from mailrelay1-us-west.apache.org (mailrelay1-us-west.apache.org [209.188.14.139]) by mx1-lw-us.apache.org (ASF Mail Server at mx1-lw-us.apache.org) with ESMTP id 575E85FB12 for ; Wed, 1 Feb 2017 16:39:52 +0000 (UTC) Received: from jira-lw-us.apache.org (unknown [207.244.88.139]) by mailrelay1-us-west.apache.org (ASF Mail Server at mailrelay1-us-west.apache.org) with ESMTP id C3FC9E0236 for ; Wed, 1 Feb 2017 16:39:51 +0000 (UTC) Received: from jira-lw-us.apache.org (localhost [127.0.0.1]) by jira-lw-us.apache.org (ASF Mail Server at jira-lw-us.apache.org) with ESMTP id 820CF2528A for ; Wed, 1 Feb 2017 16:39:51 +0000 (UTC) Date: Wed, 1 Feb 2017 16:39:51 +0000 (UTC) From: "Till (JIRA)" To: notifications@asterixdb.incubator.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Commented] (ASTERIXDB-1779) Processing the certain function predicates after a simple predicates MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 archived-at: Wed, 01 Feb 2017 16:39:55 -0000 [ 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)