Re: URGENT!!! Extremely slowly table access after delete

Naren Chintala wrote:
>
> This reason is Oracle reads all the blocks until the high watermark,
> irrespective of number of rows and hence the 1 minute. The only way of
> resetting the high watermark is by truncating the table.
>
> HTH.
>

I've found that rebuilding indexes is also helpful - especially if you cannot use truncate.

[alter index rebuild under 7.3+ is good for this]

Jon Waland Received on Tue Feb 17 1998 - 00:00:00 CST