Re: INFORMIX WISH LIST

Hi Greg, Greg Moye wrote: > snip ... > 2. Primary keys of fragmented tables always go in the dbspace the > database was created in, no way to relocate them or fragment them that I > can find. The doc says its "for performance reasons", but I sure don't > see why this should perform better, it's probably worse, to say nothing > of the space hassles you can create if you're not real careful. I'd > like to have the same options non PK indexes have. You can easily avoid this. Pre-create the unique index required to support the primary key. You can specify your storage requirements as normal (detached, fragmented, whatever). When you add the PRIMARY KEY constraint using ALTER TABLE, it will use the existing index. Chris -- Chris Jenkins (chrisj@informix.com) Advanced Technology Group >>> All statements and opinions are mine and should in no way <<< >>> be construed as representing those of Informix Software <<<