From oracle-l-bounce@freelists.org Tue Dec 6 12:47:19 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id jB6IlJ04028530 for ; Tue, 6 Dec 2005 12:47:19 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id jB6IlBAX028485 for ; Tue, 6 Dec 2005 12:47:11 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id D124624B75D; Tue, 6 Dec 2005 13:47:05 -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 11892-09; Tue, 6 Dec 2005 13:47:05 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 4553724B7EA; Tue, 6 Dec 2005 13:47:05 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Tue, 06 Dec 2005 13:45:03 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id C243524A9C7 for ; Tue, 6 Dec 2005 13:45:01 -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 11203-07 for ; Tue, 6 Dec 2005 13:45:01 -0500 (EST) Received: from mx2003bridge.wkhmr.loc (mx2003bridge.ovid.com [198.112.234.243]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 652CC24B61C for ; Tue, 6 Dec 2005 13:45:01 -0500 (EST) Received: from mx2003slc.wkhmr.loc ([198.242.51.161]) by mx2003bridge.wkhmr.loc with Microsoft SMTPSVC(6.0.3790.211); Tue, 6 Dec 2005 13:45:07 -0500 X-MimeOLE: Produced By Microsoft Exchange V6.5.7226.0 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C5FA95.2A90E567" Subject: Function based indexes? Date: Tue, 6 Dec 2005 11:45:02 -0700 Message-ID: <1281A180EA0BA140A960BE789EFAD2A80415E104@mx2003slc.wkhmr.loc> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Function based indexes? Thread-Index: AcX6lSquZgCKgE2pTtmH2cdBkoGu/w== From: "Rick Stephenson" To: X-OriginalArrivalTime: 06 Dec 2005 18:45:07.0546 (UTC) FILETIME=[2DCDCBA0:01C5FA95] X-archive-position: 28944 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: RStephenson@Ovid.com Precedence: normal Reply-To: RStephenson@Ovid.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-mailscan-MailScanner-Information: Please contact the ISP for more information X-mailscan-MailScanner: Found to be clean X-MailScanner-From: oracle-l-bounce@freelists.org X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Level: X-Spam-Status: No, hits=-4.7 required=5.0 tests=BAYES_00,HTML_60_70, HTML_MESSAGE autolearn=no version=2.63 ------_=_NextPart_001_01C5FA95.2A90E567 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Is there a way to create an index on a column and only index those where the value meets a certain expression? For example, if I have a numeric column, can I just have the index built for those values that equal 1? I don't query on any other value, so I don't want to consume the space for the other values. I am running EE 9.2.0.3. =20 Thanks, =20 Rick Stephenson =20 ------_=_NextPart_001_01C5FA95.2A90E567 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Is there a way to create an index on a column and = only index those where the value meets a certain expression?  For example, if = I have a numeric column, can I just have the index built for those values that = equal 1?  I don’t query on any other value, so I don’t want to consume = the space for the other values.  I am running EE = 9.2.0.3.

 

Thanks,

 

Rick Stephenson

 

------_=_NextPart_001_01C5FA95.2A90E567-- -- http://www.freelists.org/webpage/oracle-l