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.