Re: Indexes: Attached or Detached?

Posted in 1999

Thomas J. Girsch — Wed, 21 Apr 1999 14:44:25 -0400 — source: Informix-list mailing list archive (1991-1998)

Thanks, this is a very good, detailed message. I asked because I've heard that detached indexes tend to be faster, but I'm seeing mucho fragmentation (the bad kind) on these indexes, and I know of no way to control the extent sizes of indexes. I'm wondering if there's a point of diminishing returns there. Also, if the indexes are spread to the four corners of the globe, read-ahead is doing a lot less good, because the indexes are no longer continuous on disk. Thanks for the tips. If I do any testing of my own, I'll let the group know what I find. ----- Original Message ----- From: Mark Collins <mcollins@us.dhl.com> To: <informix-list@iiug.org> Cc: Thomas J. Girsch <tgirsch@iname.com>; <Sujit.Pal@BankAmerica.com> Sent: Wednesday, April 21, 1999 12:31 PM Subject: Re: Indexes: Attached or Detached? > Some time back, I ran a few test cases, with the following results: > > (results clipped out for brevity).