Return-Path: X-Original-To: oracle-l@orafaq.com Delivered-To: oracle-l@orafaq.com Received: from puck1183.startdedicated.com (localhost [127.0.0.1]) by puck1183.startdedicated.com (Postfix) with ESMTP id 336EC1960AB2 for ; Thu, 6 Jun 2013 17:18:49 +0200 (CEST) Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by puck1183.startdedicated.com (Postfix) with ESMTP for ; Thu, 6 Jun 2013 17:18:49 +0200 (CEST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 49BD322C5C; Thu, 6 Jun 2013 11:05:38 -0400 (EDT) X-Virus-Scanned: Debian amavisd-new at turing.freelists.org Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id PcMyQFlBQ8Q0; Thu, 6 Jun 2013 11:05:38 -0400 (EDT) Received: from turing.freelists.org (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 132C122BE7; Thu, 6 Jun 2013 11:04:57 -0400 (EDT) Received: with ECARTIS (v1.0.0; list oracle-l); Thu, 06 Jun 2013 11:04:16 -0400 (EDT) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id D41FF22BA1 for ; Thu, 6 Jun 2013 11:04:15 -0400 (EDT) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id nJBg1syT3lJL for ; Thu, 6 Jun 2013 11:04:15 -0400 (EDT) Received: from pps.mail.medcity.net (hcacorpqol.net [199.91.33.184]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 750B322B54 for ; Thu, 6 Jun 2013 11:04:13 -0400 (EDT) Received: from pps.filterd (NADCLZMSGPMG01A [127.0.0.1]) by NADCLZMSGPMG01A.medcity.net (8.14.4/8.14.4) with SMTP id r56FCqvC029190 for ; Thu, 6 Jun 2013 10:17:21 -0500 Received: from pps.mail.medcity.net ([10.26.43.100]) by NADCLZMSGPMG01A.medcity.net with ESMTP id 1ctvrx0auw-1 (version=TLSv1/SSLv3 cipher=AES256-SHA bits=256 verify=NOT) for ; Thu, 06 Jun 2013 10:17:21 -0500 Received: from pps.filterd (NADCLPMSGPMG02A [127.0.0.1]) by NADCLPMSGPMG02A.hca.corpad.net (8.14.4/8.14.4) with SMTP id r56FGl4B022379 for ; Thu, 6 Jun 2013 10:16:49 -0500 Received: from nadcwpmsght01.hca.corpad.net (nrdc-f5-frontside.mgmt.medcity.net [10.26.109.5]) by NADCLPMSGPMG02A.hca.corpad.net with ESMTP id 1ctuffr9y8-1 (version=TLSv1/SSLv3 cipher=RC4-MD5 bits=128 verify=NOT) for ; Thu, 06 Jun 2013 10:16:49 -0500 Received: from NADCWPMSGCMS10.hca.corpad.net ([10.26.103.29]) by nadcwpmsght01.hca.corpad.net ([10.26.103.51]) with mapi; Thu, 6 Jun 2013 10:16:48 -0500 From: To: Date: Thu, 6 Jun 2013 10:16:48 -0500 Subject: Partitioned Explain Plan - Pstart/Pstop = KEY after execution Thread-Topic: Partitioned Explain Plan - Pstart/Pstop = KEY after execution Message-ID: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: acceptlanguage: en-US Content-type: text/plain MIME-Version: 1.0 Content-Transfer-Encoding: 8bit X-archive-position: 49202 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: Christopher.Taylor2@parallon.net Precedence: normal Reply-To: Christopher.Taylor2@parallon.net List-help: List-unsubscribe: List-software: Ecartis version 1.0.0 List-Id: oracle-l X-List-ID: oracle-l List-subscribe: List-owner: List-post: List-archive: X-list: oracle-l Env: 10.2.0.4 RAC Linux 64-bit I've got an explain plan with Pstart/Pstop with "KEY" instead of partition numbers. I've been reading http://www.oracle.com/technetwork/database/bi-datawarehousing/twp-explain-the-explain-plan-052011-393674.pdf (The Oracle Optimizer Explain the Explain Plan) and it explains that KEY is used when Oracle believes the execution will dynamically partition prune. So I executed my statement and traced it (of course) and still the explain plan shows KEY KEY and running it through orasrp shows that many partitions were scanned (perhaps not all of them however - I haven't checked). So, is it safe to say that *after* execution if the plan has KEY KEY then partition pruning did not occur? Thanks!! Chris Taylor Oracle DBA Parallon IT&S -- http://www.freelists.org/webpage/oracle-l