Re: Clustered index question
Hi Keith,
as Peter Lancashire answered, you'll have to set DELIMIDENT to 1
and use double quotes to be able to alter the index. You can change
the index back using: 'alter index " 336_226" to not cluster;'.
This statement can be used, if you want to cluster another index.
However as I'm a friend of "user-defined" index-names; so I'd do
what you'd do: drop constraint; create index; add constraint;
I've got another problem with your question: if you alter an
existing index (i_abcd in your case) to cluster, the name remains
the same, even if there are constraints using this index. So you
probably didn't alter the index but drop id (informix creates one
to maintain your constraint).
Peter
--
_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
_/_/ Mag. Peter Kolmhofer __ _ _____ _/
_/_/ Informix & DB2 DBA __ --/_|___\\______ _/
_/_/ Porsche Informatik (Austria) _ _ ( _ _ \\) _/
_/_/ A-5101 Bergheim, Handelszentrum 7 -(_)-------(_)- _/
_/_/ +43 662 4670-6258 fax: -6501 email:kop@porsche.co.at _/
_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
KPonn wrote:
> 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> the
> constraint 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