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 -> Index Question

Index Question

From: Van Messner <vmessner_at_netaxis.com>
Date: Mon, 10 May 1999 17:58:27 -0400
Message-ID: <0KIZ2.1978$LP2.40455@news6.ispnews.com>


Under version 7.3:
I have a 1 Gig table with 9 million rows. One column is a number(12). This column is not unique and there are about 500 rows for each different number. The column has a non-unique index which takes about 300M. The table is updated frequently.

Is this index giving enough benefit to justify the additional 300 Meg? It's reasonably selective but the column on which it's based is a short number. Based on the size of the index it seems like the index values might be longer than the column values. Is that a problem?

Thanks

Van Received on Mon May 10 1999 - 16:58:27 CDT

Original text of this message

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