Re: how to create an index on serial column

Jaswant Bhardwaj (jaswant@highland.eng.octel.com) wrote: : 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. As already mentioned, depending on how you created the table, you may already have an index on the column (try Table/Info/Indexes to find out). Otherwise, try doing it from Query-Language: CREATE INDEX ixname ON tabname (serialcolumn); June ---- June Tong Informix Software ---- ---- junet@informix.com (415) 926-6140 ----