Re: how to create an index on serial column

Hi Jaswant, A unique index is automatically built on a serial column. If you're noticing poor performance, it could be for a number of reasons. If you've built several indexes on other columns as your note suggests, these can greatly slow down any updates, inserts, or deletes. Otherwise, if your reads are slow, check your SQL syntax. Hope this helps! STEVE ____ ___ ________ ________ /_ _] /_ ]/ ______)/ ______) _/| Steve Morrow, Sr. Programmer/Analyst / _/ / / / (____ / /___ _/ | University of South Florida / _/ / / \\____ ) / _____) _/ | Internet: smorrow@dotrisc.cfr.usf.edu / _/___/ / ______/ / / / _/ | Voice : (813) 974-6889 (_________)(________)(___)______/ |______________________________________ Jaswant Bhardwaj (jaswant@highland.eng.octel.com) wrote: : 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.