Return-Path: X-Original-To: apmail-ignite-user-archive@minotaur.apache.org Delivered-To: apmail-ignite-user-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 32F06188BF for ; Mon, 11 Apr 2016 01:34:32 +0000 (UTC) Received: (qmail 5590 invoked by uid 500); 11 Apr 2016 01:34:32 -0000 Delivered-To: apmail-ignite-user-archive@ignite.apache.org Received: (qmail 5540 invoked by uid 500); 11 Apr 2016 01:34:31 -0000 Mailing-List: contact user-help@ignite.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@ignite.apache.org Delivered-To: mailing list user@ignite.apache.org Received: (qmail 5530 invoked by uid 99); 11 Apr 2016 01:34:31 -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; Mon, 11 Apr 2016 01:34:31 +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 6706B18028D for ; Mon, 11 Apr 2016 01:34:31 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd3-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: -2.322 X-Spam-Level: X-Spam-Status: No, score=-2.322 tagged_above=-999 required=6.31 tests=[RCVD_IN_DNSWL_MED=-2.3, RCVD_IN_MSPIKE_H3=-0.01, RCVD_IN_MSPIKE_WL=-0.01, RP_MATCHES_RCVD=-0.001, SPF_PASS=-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 qIkEumm9ra8B for ; Mon, 11 Apr 2016 01:34:28 +0000 (UTC) Received: from szxga03-in.huawei.com (szxga03-in.huawei.com [119.145.14.66]) by mx1-lw-us.apache.org (ASF Mail Server at mx1-lw-us.apache.org) with ESMTPS id 433385F239 for ; Mon, 11 Apr 2016 01:34:26 +0000 (UTC) Received: from 172.24.1.36 (EHLO nkgeml411-hub.china.huawei.com) ([172.24.1.36]) by szxrg03-dlp.huawei.com (MOS 4.4.3-GA FastPath queued) with ESMTP id BZP02838; Mon, 11 Apr 2016 09:34:16 +0800 (CST) Received: from NKGEML513-MBX.china.huawei.com ([169.254.1.56]) by nkgeml411-hub.china.huawei.com ([10.98.56.70]) with mapi id 14.03.0235.001; Mon, 11 Apr 2016 09:34:11 +0800 From: Zhengqingzheng To: "user@ignite.apache.org" Subject: re: Ignite Sql Query performance problem Thread-Topic: Ignite Sql Query performance problem Thread-Index: AQHRk3V0RfFwe49l8kCtKHi++jX9gZ+D8J1Q Date: Mon, 11 Apr 2016 01:34:10 +0000 Message-ID: References: <1460192651416-4031.post@n6.nabble.com> <1460325246766-4041.post@n6.nabble.com> In-Reply-To: <1460325246766-4041.post@n6.nabble.com> Accept-Language: zh-CN, en-US Content-Language: zh-CN X-MS-Has-Attach: X-MS-TNEF-Correlator: x-originating-ip: [10.135.66.169] Content-Type: text/plain; charset="gb2312" Content-Transfer-Encoding: base64 MIME-Version: 1.0 X-CFilter-Loop: Reflected X-Mirapoint-Virus-RAPID-Raw: score=unknown(0), refid=str=0001.0A020203.570AFF19.001B,ss=1,re=0.000,recu=0.000,reip=0.000,cl=1,cld=1,fgs=0, ip=169.254.1.56, so=2013-05-26 15:14:31, dmn=2013-03-21 17:37:32 X-Mirapoint-Loop-Id: 30a9f642e7aab7dcba218496252c5156 SGkgVmFsLCANClRoYW5rIHlvdSBmb3IgeW91ciBxdWljayByZXNwb25zZS4gDQpJIGNoZWNrZWQg bXkgamF2YSBjbGFzcyBhbm5vdGF0aW9uLCBJIGRpZCBub3QgYWRkIGluZGV4IG9wdGlvbnMgb24g dGhlIGRlZmluaXRpb24uIA0KTXkgb3JpZ2luYWwgamF2YSBzZXR0aW5nIGxvb2tzIGxpa2UgdGhp czoNCiAgICBAUXVlcnlTcWxGaWVsZA0KICAgIHByaXZhdGUgU3RyaW5nIG9iaklkOw0KQWZ0ZXIg YWRkaW5nIGluZGV4IGZsYWc6DQogICAgQFF1ZXJ5U3FsRmllbGQoaW5kZXggPSB0cnVlKQ0KICAg IHByaXZhdGUgU3RyaW5nIG9iaklkOw0KaXQgZG9lcyBzcGVlZCB1cCBteSBxdWVyeSBkZW1vLiBO b3csIG9uZSB0aG91c2FuZCB0aW1lIHF1ZXJ5IG9ubHkgdGFrZSAzOTdtcywgb24gYXZlcmFnZSBs ZXNzIHRoYW4gMW1zIHBlciBxdWVyeSAobXkgZXhhbXBsZSBkYXRhc2V0IGNvbnRhaW5zIG9ubHkg MTcsMDAwIGRhdGEgcmVjb3JkcykuDQpUaGFuayB5b3UgZm9yIHlvdXIgaGVscC4NCg0KT25lIG1v cmUgcXVlc3Rpb246IHdoYXQgaWYgSSBoYXZlIG11bHRpcGxlIGluZGV4ZXMgb24gbXkgdGFibGUs IGFmdGVyIHNldHRpbmcgaW5kZXg9dHJ1ZSwgd2hhdCBpcyB0aGUgY29zdCBmb3IgdGhlIG1lbW9y eSB1c2FnZT8NCg0KDQpCZXN0IHJlZ2FyZHMsDQpLZXZpbg0KLS0tLS3Tyrz+1K28/i0tLS0tDQq3 orz+yMs6IHZrdWxpY2hlbmtvIFttYWlsdG86dmFsZW50aW4ua3VsaWNoZW5rb0BnbWFpbC5jb21d IA0Kt6LLzcqxvOQ6IDIwMTbE6jTUwjExyNUgNTo1NA0KytW8/sjLOiB1c2VyQGlnbml0ZS5hcGFj aGUub3JnDQrW98ziOiBSZTogSWduaXRlIFNxbCBRdWVyeSBwZXJmb3JtYW5jZSBwcm9ibGVtDQoN CkhpLA0KDQpNb3N0IGxpa2VseSB5b3UgZG9uJ3QgaGF2ZSBpbmRleGVzIGFuZCB0aGUgcXVlcnkg aGFzIHRvIHNjYW4gdGhlIHdob2xlIGNhY2hlIHRvIGZpbmQgdGhlIGRhdGEgeW91J3JlIHJlcXVl c3RpbmcuIENhbiB5b3Ugc2hvdyB5b3VyIGNvbmZpZ3VyYXRpb24gYW5kIHRoZSBTUUwgc3RhdGVt ZW50IHRoYXQgeW91J3JlIGV4ZWN1dGluZz8NCg0KLVZhbA0KDQoNCg0KLS0NClZpZXcgdGhpcyBt ZXNzYWdlIGluIGNvbnRleHQ6IGh0dHA6Ly9hcGFjaGUtaWduaXRlLXVzZXJzLjcwNTE4Lng2Lm5h YmJsZS5jb20vSWduaXRlLVNxbC1RdWVyeS1wZXJmb3JtYW5jZS1wcm9ibGVtLXRwNDAzMXA0MDQx Lmh0bWwNClNlbnQgZnJvbSB0aGUgQXBhY2hlIElnbml0ZSBVc2VycyBtYWlsaW5nIGxpc3QgYXJj aGl2ZSBhdCBOYWJibGUuY29tLg0K