Re: fragementing a table w/ unique indx
not having the sql statement, ill take a guess on this one:
the following statement doesnt work:
create table bob2
(
col1 serial not null,col2 integer
)
with rowids
fragment by round robin in rootdbs, bsi_01, bsi_02, bsi_03;
create unique index pk_bob2 on bob2 (col1,col2);
872: Invalid fragment strategy or expression for the unique index.
but, you can get the desired results by:
create table bob2
(
col1 serial not null,
col2 integer,
primary key (col1,col2)
)
with rowids
fragment by round robin in rootdbs, bsi_01, bsi_02, bsi_03;
INFO - bob2: Columns Indexes Privileges Status Table Exit
Display information about indexes for the columns in a table.
----------------------- testing ---------------- Press CTRL-W for Help --------
Index name Owner Type Cluster Columns
135_6 baskett unique No col1
col2
>
> 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 |
>
--
regards,
+----------------------------------------------------------------------------+
| . . | Bob Baskett |
| ... ... | Software Engineer |
| ..... ..... | Business Systems Integration Group |
| .. ... .. | Semiconductor Products Sector |
| . . . | Mesa, AZ |
| | President, Informix Users Group Of Arizona |
| Motorola, Inc. | |
+----------------------------------------------------------------------------+
| Sun 690MP 4.1.3, Online 5.01, 4.10.UD1 Tools, Fourgen v4.10.UC1 |
+----------------------------------------------------------------------------+