From oracle-l-bounce@freelists.org Sat Jan 1 21:09:11 2005 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id j0239B730704 for ; Sat, 1 Jan 2005 21:09:11 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id j0239Bn30699 for ; Sat, 1 Jan 2005 21:09:11 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 7DCB472C66D; Sat, 1 Jan 2005 22:15:43 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 29124-28; Sat, 1 Jan 2005 22:15:43 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 060CE72C977; Sat, 1 Jan 2005 22:14:13 -0500 (EST) Message-ID: <41D7665F.3050707@oracle.com> Date: Sat, 01 Jan 2005 19:11:27 -0800 From: Vladimir Begun Organization: Oracle Corporation User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.7.3) Gecko/20040910 X-Accept-Language: en-us, en, ru MIME-Version: 1.0 To: oracle-l@freelists.org Cc: awellsdba@gmail.com Subject: Re: B-Tree to Partitioned index References: <41D758AE.7070805@oracle.com> In-Reply-To: <41D758AE.7070805@oracle.com> Content-type: text/plain; charset=us-ascii Content-Transfer-Encoding: 8bit X-archive-position: 14290 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: Vladimir.Begun@oracle.com Precedence: normal Reply-To: Vladimir.Begun@oracle.com X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org One possible improvement: CREATE INDEX employees_local_idx ON employees (employee_id, SUBSTR(CAST(NULL AS VARCHAR2(1)), 1, 1)) LOCAL UNUSABLE / This would allow the index to remain slim for ONLINE rebuild: fake column is everytime NULL and it's datatype is VARCHAR2(1) I believe, it's enough for ONLINE rebuild. -- Vladimir Begun The statements and opinions expressed here are my own and do not necessarily represent those of Oracle Corporation. -- http://www.freelists.org/webpage/oracle-l