tool for deleting table's data?

[asd234]

Hi;
I'm looking for different methods of deleting the data of a very large table(with milions of records), because using "delete" statement takes more than 4 hours to perform and Ido need a faster method.Please send me your sugestions.
[I'm running on informix dynamic server 7.3 with unixware platform]
With regards.

 

[dodge20]

Probably the fastest and most efficient in terms of less fragmentation would be to drop the table and rebuild it from scratch.

 

[olded]

Hi:

dodge20 is right if you need to eliminate all the data in a table. If there's data you need to save, One other thing you can do is use the High Performance Loader to unload the data, drop and recreate the table, and reload the saved data.

One other technique I've used is to rename the table in question. From isql/dbaccess query language:

rename table tablename to oldtablename

Then recreate tablename. Now, I can work on oldtablename at my liesure.

Regards,


Ed