Re: how to create an index on serial column

At 12:31 PM 8/15/95 GMT, Steve Morrow wrote: }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. } } -- Bob Rusk rrusk@fll-ro.DHL.COM