Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Select are slow after delete command
Erm - truncate kills ALL rows in the table, which isn't what the original
poster wanted...and you can't rollback from a truncate. BEWARE
Bruno Plankensteiner wrote in message <37A1ABE3.30F29A08_at_ctp.com>...
>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 - 09:28:41 CDT