Re: how to create an index on serial column

> jaswant@highland.eng.octel.com (Jaswant Bhardwaj) writes: > > Hi > i'm new to informix, so please forgive if it is > a very trival question (i'm sure it is). > > > 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 say very litle about your products (version numbers, table design++) It sounds like you allready have an index on the serial column. It's common to designate the serial column as the primary key. In that case Informix generated an index for you, and you can't generate another one yourself. Nils.Myklebust@ccmail.telemax.no NM-data, Dalsbergstien 7, N-0170 Oslo, Norway My opinions are those of my company