Re: how to create an index on serial column

Posted in 1995

John Prideaux — 7 Aug 1995 13:55:01 GMT — source: Informix-list mailing list archive (1991-1998)

In <JASWANT.95Aug5172038@highland.eng.octel.com> jaswant@highland.eng.octel.com (Jaswant Bhardwaj) writes: > > > > i have serial number column and i want to create an index >on it since performance is slow. i can create indces on all other >columns except this one by using isql->table-Alter screens. > You should not be able to do this under isql->table->alter because you should not be able to change a serial column to anything other than a non-serial column. Use CREATE INDEX under query-language to create the unique index. John Prideaux alastl@ix.netcom.com