Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Shrinking an index??

Re: Shrinking an index??

From: Christina Villmer <Christina.Villmer_at_lhsystems.com>
Date: 1997/03/18
Message-ID: <332F33E3.2513@lhsystems.com>#1/1

Z. Martinez wrote:
>
> Here is my situation...
>
> I have a large table, a very large table, about one million rows.
> The table definition goes something like this.
>
> id number(10)
> type number(3)
> desc char(40)
> .
> .
> .
>
> There are several select statements that are going query on this
> table, but only needs types 5 and 9, i.e type = 5 or type = 9.
> This is probably just 10% of the entire table or 100,000 rows.
>
> There is currently an index that keys on the "type" column.
> It certainly looks like a waste of storage and processing, cause the
> remaining 900,000 entries are not really needed.
>
> Is there a way to create an index such that only a subset of the table
> is indexed? I would like to shrink the index to save space and
> hopefully increase the performance of the queries.
>
> Please respond to zlm101_at_psu.edu
>
> Thanks in advance.

Hi!
I'm not sure if this is the better way, but try this (if you like): I wouldn't use the index over the whole table. I would create a view on the table with only the types you need. And then just query on the view..!

-- 
Christina Villmer
(Lufthansa Systems GmbH, Germany)
Received on Tue Mar 18 1997 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US