Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Select are slow after delete command

Re: Select are slow after delete command

From: Bruno Plankensteiner <bplank_at_ctp.com>
Date: Fri, 30 Jul 1999 15:43:00 +0200
Message-ID: <37A1ABE3.30F29A08@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 - 08:43:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US