At 08:41 PM 9/25/2006, you wrote:
>Dilipkumar wrote:
>>Hi,
>>Its delete * from table will only do if you go for a truncate it will
>>recreate the table structure ?....
>>It's better to use delete.
>
>Can you explain why? I'd go for instant truncate rather than waiting
>around for delete to finish.

The drawback of truncate is it requires a table lock and if people are
updating the table, the truncate will have to wait for the locks to
complete. There is also RI to worry about.

Mike