Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Select are slow after delete command
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_at_hwlab.felk.cvut.cz
Received on Fri Jul 30 1999 - 08:43:00 CDT