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).