Re: Select are slow after delete command

From: tmgn <tmgn_at_excite.com>
Date: Fri, 30 Jul 1999 10:34:26 -0400
Message-ID: <37A1B7F2.A5D98C09@excite.com>

The reason is that the High Water Mark for the Table Segment may not be reset by deleting the rows..Truncate does that..

-Thiru

Bruno Plankensteiner wrote:

Try it with the truncate command. It will keep you the structure of the table.
Bruno

Bøetislav Èerník wrote:

> Hello
> I found the folowing trouble.
> When I delete many rows in table, the select works as slow as there are all
> rows.
> Are there any way, how can I clean table without drop table?
>
> Bretislav Cernik
> xcernikb@hwlab.felk.cvut.cz

Received on Fri Jul 30 1999 - 09:34:26 CDT