Re: Clustered Index

Hi, if you want to create your clustered index you should follow the steps: 1.) drop the primary key constraint ( this will drop the index, too ). 2.) create an UNIQUE CLUSTER index. 3.) update statistics for that table 4.) finally add your primary key definition Before you add a primary key/foreign key constraint you should always create the indexes by yourself. Be carefull ! Informix will generate it's own indexes (for the pk/fk constraints ) if you would drop ( re-create ) your indexes afterwards, if you would not drop your constraints before. Bye Stefan PS: "dbschema" will NOT destroy the order : create table - create index - alter table add primary key Reghu R. Nair wrote: > > Friends, > I'm trying to change unique index in a table to unique clustered > index using dbaccess in informix online dynamic server 7.12. > > I've used 'ALTER INDEX index-name TO CLUSTER'.But it is giving > me a syntax error(-201).The index also happens to be the primary key > and its name is 105_14(since i've not given any explicit create index > statement). > Then i tried dropping the index using 'Drop index 105_14'. > But it gave me the same syntax error.What am i missing here? > Any help in this matter would be greatly appreciated. > > Thanks in advance > Reghu R.Nair > > mailto:reghu@comsysmgt.com >