Indexes - Are yours larger then the table?
From: Daryl Erwin <derwin_at_mach2.wlu.ca>
Date: Thu, 22 Oct 1992 02:46:36 GMT
Message-ID: <BwI51p.C44_at_mach1.wlu.ca>
Date: Thu, 22 Oct 1992 02:46:36 GMT
Message-ID: <BwI51p.C44_at_mach1.wlu.ca>
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?
Any and all comments welcome.
-- Daryl Erwin Net Address: derwin_at_mach2.WLU.CA Computing Services Surface Mail: P4-1, Main Campus Wilfrid Laurier University, Waterloo, Ontario Bus:(519) 884-1970 x2910 ... Go Hawks!Received on Thu Oct 22 1992 - 03:46:36 CET