Re: Truncate Table?

From: <markp7832_at_my-deja.com>
Date: Thu, 18 Nov 1999 20:13:11 GMT
Message-ID: <811mk2$9jh$1@nnrp1.deja.com>

In article <811ccj$68618_at_imsp212.netvigator.com>, "ccdicky" <ccdicky_at_yahoo.com> 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
>

The indexes have their HWM (high water mark) reset just like the table.

--
Mark D. Powell -- The only advice that counts is the advice that you follow so follow your own advice --

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Nov 18 1999 - 14:13:11 CST