Re: Detached indices in 7.3

SaTriGuy wrote: [SNIP] > Even so - I would not worry about detached/attached indexes. If this is > implemented like it is in 9.x, then the indexes will be created as detached, > but existing attached indexes will be functional. There is a performance > benifit by having detached indexes inplace of attached indexes (i.e. data scans > do not have to "skip" pages), and the total space required should be identical. > > Madison Pruet Are you sure that the *total* space will be the same? I seem to recall that Tony Adduchi <sp?> gave a quick talk on a project at Sears. He mentioned that one strange phenomonon was that the index space was the same size as the table space. It appears that Informix has one set of variables used to calculate space requirements. Of course this was 7.2x so hopefully it was fixed. -Mikey BTW, Chicago's Usergroup Meeting is scheduled for Fri March 13th. -- #include <std_disclaimer.h> /* Mike Segel (MS385) */ #include <No_Spam.h> #ifdef OFFENDED_BY_CONTENT The author takes no responsibility for this post. Any resemblence to a coherent rational thought is purely coincidence. -The Management. #endif ***************************** Due to AGIS's Refusal to Act Responsibly We are blocking all of their domains at the packet level. This block will exist until AGIS modifies their policies to conform to existing RFCs and net community standards. We encourage all ISPs and domain holders to do the same. *****************************