Re: clear table fast ?

axime wrote:
>
> Hi !
>
> 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?
>
> TIA,
> Uwe

Yes, Use the foll command.

TRUNCATE table <table_name>;

-- 

Regards,

Varad Acharya

 The above statements and opinions are my own and do not
 necessarily represent those of Ford Motor Company.