Re: Help Deleting Records

Posted in 1996

Joseph Kormann — 6 Jun 1996 13:41:28 GMT — source: Informix-list mailing list archive (1991-1998)

Glenn Travis (gtravis@richmond.infi.net) wrote: : When is Informix going to allow 'TRUNCATE TABLE tablename' ??? All the other : guys have it... Also, 'CREATE TABLE tablename AS SELECT * from tablename1' is : much needed... : In article <4p3b3s$3s5@sparcserver.lrz-muenchen.de>, : spitz@GANS2X.ana.med.uni-muenchen.deW says... : > <snip> Rather than unloading/loading, creating an index etc.. just do a bcheck on the table? We found it frees up the memory alot faster. Of course if you don't have access to a bcheck.... <shrug> -Joseph