Re: How is disk space allocated to Indexes? - Correction.

Posted in 1998

Peter Tashkoff — Fri, 13 Mar 1998 08:21:28 +1300 — source: Informix-list mailing list archive (1991-1998)

I foolishly said .... =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D If you detach the index the extent size of the index is the same size as = the extent size of the underlying table, which is a bit restrictive. =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D Thanks to Mark Collins for putting me right. The extent size of the = detached index is based upon the extent size of the table but also takes = into account the key size and fillfactor, as detailed in Marks post on = this subject. All of which makes detached indexing in Informix a whole lot more useful = than I thought is was, and I unreservedly apologise to anyone I might have = misled on this point, alongwith the engineers at Informix for implying = that Oracle was ahead of them on this point. I shoulda known better = shouldn't I? rgds Peter Tashkoff