Re: how to create an index on serial column

At 06:24 PM 8/10/95 GMT, June Tong wrote: }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 ---- } } -- Bob Rusk rrusk@fll-ro.DHL.COM