Oninit cdi / Archive
Talk to an expert →

Fine tuning Deletion

Posted in 1999

Topics: Performance & Tuning, Connectivity: ESQL/C, 4GL & Embedded SQL, Versions, Editions & End-of-Life

Ganesh Sankar — — source: Informix-list mailing list archive (1991-1998)

Hi, What are the parameters or other factors to be considered/set when deleting large no of rows? I can not use drop and recreate as an other option. Thanks in advance. Environ: IDS 7.30.UC7, 4GL - 6.05.UD1 Shankar __________________________________________________ Do You Yahoo!? Bid and sell for free at http://auctions.yahoo.com

↪ replying to Ganesh Sankar
Phillip Tien — — source: Informix-list mailing list archive (1991-1998)

if this is a heavily accessed table, and you have indexes on it, you should drop and recreate the indexes on a fairly regular basis, depending on how much inserts/deletes/updates happen on the table. The more modifications you do to the table, the more frequent you should recreate your indexes. Another option would be to cluster the indexes each time you recreate them as this will essentially re-write the table to fill up all the unused space from deletions within the tablespace. Ganesh Sankar wrote: > Hi, > > What are the parameters or other factors to be considered/set when > deleting large no of rows? I can not use drop and recreate as an other > option. > > Thanks in advance. > > Environ: > IDS 7.30.UC7, 4GL - 6.05.UD1 > > Shankar > > __________________________________________________ > Do You Yahoo!? > Bid and sell for free at http://auctions.yahoo.com -- Phillip Tien, DBA Whole Foods Market 512.477.5566 ext. 1226 "I always wanted to be the last guy on Earth, just to see if all those women were lying to me."

↪ replying to Phillip Tien
David Williams — — source: Informix-list mailing list archive (1991-1998)

In article <37CAB396.B0FD007D@wholefoods.com>, Phillip Tien <phillip.tien@wholefoods.com> writes >Ganesh Sankar wrote: > >> Hi, >> >> What are the parameters or other factors to be considered/set when >> deleting large no of rows? I can not use drop and recreate as an other >> option. >> Make sure that any indexes on the table are unique. If necessary add additional columns to the end of the index to make it unique. This can dramatically speedup deletions. >> Thanks in advance. >> >> Environ: >> IDS 7.30.UC7, 4GL - 6.05.UD1 >> >> Shankar >> >> __________________________________________________ >> Do You Yahoo!? >> Bid and sell for free at http://auctions.yahoo.com > >-- >Phillip Tien, DBA >Whole Foods Market >512.477.5566 ext. 1226 > >"I always wanted to be the last guy on Earth, just to see if all those >women were lying to me." > > -- David Williams

Glossary