Re: clear table fast ?

axime wrote:
> I need to remove all (~100.000) rows from a (temporary) table.
> What is the fastest way to do this? Is it possible to do something like
> a 'modify to truncated' in Ingres, i.e. without logging the
> transactions?

  You can use TRUNCATE tablename to achieve your purpose.

---
Name   : Lun Wing San
Title  : Oracle Application Developer of Hong Kong Productivity Council
         Oracle Database Administrator and System Administrator of QRC
Phone  : (852)27885841