Return-Path: Delivered-To: 2-oracle-l@orafaq.com Received: (qmail 16316 invoked from network); 5 Dec 2007 10:51:09 -0600 Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180) by 69.64.49.119 with SMTP; 5 Dec 2007 10:51:09 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 678F57D0CEE; Wed, 5 Dec 2007 11:51:09 -0500 (EST) 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 25190-05; Wed, 5 Dec 2007 11:51:09 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id D5D5B7D08F2; Wed, 5 Dec 2007 11:51:08 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Wed, 05 Dec 2007 11:49:01 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 415077D0077 for ; Wed, 5 Dec 2007 11:49:01 -0500 (EST) 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 24604-06 for ; Wed, 5 Dec 2007 11:49:01 -0500 (EST) Received: from smtp14.singnet.com.sg (smtp14.singnet.com.sg [165.21.6.24]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 8CB837CFE7E for ; Wed, 5 Dec 2007 11:48:59 -0500 (EST) Received: from chitale.singnet.com.sg (bb220-255-243-226.singnet.com.sg [220.255.243.226]) by smtp14.singnet.com.sg (8.14.1/8.14.1) with ESMTP id lB5GmkA9004534 for ; Thu, 6 Dec 2007 00:48:46 +0800 Message-Id: <200712051648.lB5GmkA9004534@smtp14.singnet.com.sg> Date: Thu, 06 Dec 2007 00:48:51 +0800 To: ORACLE-L@freelists.org From: Hemant K Chitale Subject: MultiColumn Range / Range-List Partitioning Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii"; format=flowed X-archive-position: 3720 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: hkchital@singnet.com.sg Precedence: normal Reply-to: hkchital@singnet.com.sg 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 X-Virus-Scanned: Debian amavisd-new at localhost.localdomain The docs do say that the Partition Key for Range Partitioning (or Hash Partitioning) can comprise of multiple columns. Has anyone used multiple columns as the Partition Key in a Range Partitioning implementation ? Further to that, use Composite Partitioning where the SubPartition is based on List Partitioning ? I understand that if a new row qualifies to fit into a particular partition based on the first column itself, the actual value in the second column doesn't matter as the desired partition has already been identified. What would be the Pros and Cons of MultiColum Partition Keys ? Of mixing with a List Partition as a SubPartition ? Hemant K Chitale http://web.singnet.com.sg/~hkchital and http://hemantscribbles.blogspot.com and http://hemantoracledba.blogspot.com "There is more to life than increasing its speed." Mohandas Gandhi Quotes : http://www.brainyquote.com/quotes/authors/m/mohandas_gandhi.html -- http://www.freelists.org/webpage/oracle-l