Clustered index question
Posted in 1998
KPonn — — source: Informix-list mailing list archive (1991-1998)
Hello,
We have a table with an index "i_abcd" on an integer column. I changed it to
clustered index using alter index statement. It turned out that this column has
a referential constraint (This I didnot see before). Now I want change it back
to non clustered index. The name of this index is changed to " 336_226" and
alter index is not working. How do I do this ? What happens if I drop theconstraint and add an index i_abcd and put the constraints back on ?
Another thing is that I see 336_226 name using dbaccess->info->index. But when
I do a dbschema on the table, it says 128_226 (not 336_226) on this column. Can
anyone comment on this - what do I need to do to change it back to non
clustered index ?
Thanks
Keith