Re: Deletes in SE

Suleman Makhani wrote: > > We have serious performance problems in SE 4.1x when we try to delete > about 400 records from a table (total 40K + records) using the following > statement: > > delete from tab1 where col1 = "xxx"> col1 is a char(20) indexed field. It takes about 30 minutes to delete > 400 records. I can insert 400 records using load statement in less than > 30 seconds. The operating system is SCO Unix 3.2V2.0. > > Any suggestions? 1- Use "bcheck" from sysop to check the indexes of the table (or "check table" / "repair table" from isql) 2- Use alter index (any index on the table) to cluster to free space of indexes and data ------------------------- Carlos Antonio Ruiz G'mez dmys2@colomsat.net.co Colombia, SurAm'rica