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