Re: fragementing a table w/ unique indx

I belive that the problem is that you cannot fragment a unique index. Since you can operate against a fragmented table when one of the fragments is down, the unique index cannot be enforced. When you created the table without fragmentation, then fragmented it, the unique index stayed on a single fragment. To verify this, you can try the same create fragment statement but tell it what fragment to put the index on. At 05:13 AM 5/12/95 GMT, Mark Steele wrote: }Am I getting myself in trouble? } }I created a table, with a unique index, and round robin }fragmentation. The engine said no way (btw it's 7.1). Then I }created the table, and altered it to round robin fragmentation, }and no problem. Is that trick going to come back and haunt me I }wonder...? } } } } }-- }| Mark Steele | }| 74431,3327@compuserve.com | }| It is nice to be important, but it is more important | }| to be nice | } }