RE: Indexes - Are yours larger then the table?

In article <BwI51p.C44_at_mach1.wlu.ca>, derwin_at_mach2.wlu.ca (Daryl Erwin) writes:
> I have a 40 meg table and the indexes are 30+ megs each! I would just
> like some assurance that this is 'normal'.Can any thing be done
> to lower this size? My table has 10 fields and the index has 2, so the
> index is carrying approx. 1/5th the data the table is but yet the index
> is so large. I chalked this upto a Binary Tree and how each node would
> need to be stored - is this the case? Can I reduce the # of levels? the
> number of elements per node or am I just stuck with what
> 'create index xyz on table abc (myfiled); ' creates?

Are you sure your INDEX is using all that space? You might have allocated something too big by using default storage parameters which include a percent increase and have a lot of allocated but unused space.

-- 

Bruce...        pihlab_at_hhcs.gov.au
                 ^^
*******************************************************************
* Bruce Pihlamae  --  Database Administration                     *
* Commonwealth Department of Health, Housing & Community Services *
* Canberra, Australia                             (W) 06-289-7056 *
*******************************************************************
* These are my own thoughts and opinions, few that I have.        *
*******************************************************************