Re: Truncate === ????

Posted in 1998

Suhas Tembe — Mon, 16 Nov 1998 11:46:28 -0500 — source: Informix-list mailing list archive (1991-1998)

Hi, The best & fastest way (if you want to delete all the records) would be to 'drop' the table & re-create it with indexes (if any). Suhas ------------------------ From: "T.Suresh Kumar" <sureshkt@hotmail.com> Subject: Truncate === ???? Date: Mon, 16 Nov 1998 19:55:29 +0000 Location: news://news.alterdial.uu.net/comp.databases.informix/36508331.746AE5D2@hotmail.com To: "comp.databases.informix" <@news:comp.databases.informix@news.alterdial.uu.net> Hi I want to delete all the records from a table with a command that is similar to TRUNCATE table tablename option in ORACLE. Can any one give me how can I delete records from table very fast without using DELETE statement? Suresh ---------------End of Original Message----------------- -------------------------------------------------------- Name : Suhas Tembe E-mail: <stembe@arrowshirt.com> Date : 11/16/98 Time : 11:46:29 Place : Atlanta, Georgia. --------------------------------------------------------