Return-Path: X-Original-To: apmail-phoenix-dev-archive@minotaur.apache.org Delivered-To: apmail-phoenix-dev-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 0541018504 for ; Sat, 23 Jan 2016 21:56:42 +0000 (UTC) Received: (qmail 62739 invoked by uid 500); 23 Jan 2016 21:56:41 -0000 Delivered-To: apmail-phoenix-dev-archive@phoenix.apache.org Received: (qmail 62679 invoked by uid 500); 23 Jan 2016 21:56:41 -0000 Mailing-List: contact dev-help@phoenix.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@phoenix.apache.org Delivered-To: mailing list dev@phoenix.apache.org Received: (qmail 62668 invoked by uid 99); 23 Jan 2016 21:56:41 -0000 Received: from Unknown (HELO spamd1-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 23 Jan 2016 21:56:41 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd1-us-west.apache.org (ASF Mail Server at spamd1-us-west.apache.org) with ESMTP id 751C7C0A2D for ; Sat, 23 Jan 2016 21:56:41 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd1-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 1.779 X-Spam-Level: * X-Spam-Status: No, score=1.779 tagged_above=-999 required=6.31 tests=[KAM_ASCII_DIVIDERS=0.8, KAM_LAZY_DOMAIN_SECURITY=1, RCVD_IN_MSPIKE_H3=-0.01, RCVD_IN_MSPIKE_WL=-0.01, RP_MATCHES_RCVD=-0.001] autolearn=disabled Received: from mx1-us-east.apache.org ([10.40.0.8]) by localhost (spamd1-us-west.apache.org [10.40.0.7]) (amavisd-new, port 10024) with ESMTP id wZU3KqpdkVVU for ; Sat, 23 Jan 2016 21:56:41 +0000 (UTC) Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by mx1-us-east.apache.org (ASF Mail Server at mx1-us-east.apache.org) with SMTP id 8608243ECF for ; Sat, 23 Jan 2016 21:56:40 +0000 (UTC) Received: (qmail 62604 invoked by uid 99); 23 Jan 2016 21:56:40 -0000 Received: from arcas.apache.org (HELO arcas) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 23 Jan 2016 21:56:40 +0000 Received: from arcas.apache.org (localhost [127.0.0.1]) by arcas (Postfix) with ESMTP id E5C732C1F58 for ; Sat, 23 Jan 2016 21:56:39 +0000 (UTC) Date: Sat, 23 Jan 2016 21:56:39 +0000 (UTC) From: "James Taylor (JIRA)" To: dev@phoenix.incubator.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Updated] (PHOENIX-2090) Refine PhoenixTableScan.computeSelfCost() when scanRanges is available MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 [ https://issues.apache.org/jira/browse/PHOENIX-2090?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Taylor updated PHOENIX-2090: ---------------------------------- Assignee: Maryann Xue > Refine PhoenixTableScan.computeSelfCost() when scanRanges is available > ---------------------------------------------------------------------- > > Key: PHOENIX-2090 > URL: https://issues.apache.org/jira/browse/PHOENIX-2090 > Project: Phoenix > Issue Type: Sub-task > Reporter: Maryann Xue > Assignee: Maryann Xue > Labels: calcite > Original Estimate: 120h > Remaining Estimate: 120h > > We should compute a more accurate cost based on the "scanRanges" so that we can better choose among these different indices. > For example, if we have more than one indices concerning different index keys, for example IDX1 is indexed on column a, and IDX2 is indexed on column b, and our query is like "select x, y, z where a between 'A1' and 'A2' and b between 'B3' and 'B4'. -- This message was sent by Atlassian JIRA (v6.3.4#6332)