Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Truncate Table?
Yes, any indexes are updated to reflect no rows in the table.
ccdicky wrote:
> Hi,
>
> Truncating tables can reset their HWMs. But how about their indexes? That
> is, the indexes belonging to the truncated table are cleaned up, just like
> "Rebuild" or "Drop and Create".
>
> Any pointer would be greatly appreicated.
>
> Dicky
Received on Thu Nov 18 1999 - 12:46:51 CST