Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Select are slow after delete command
Hi.
If you delete all rows in your table then use
TRUNCATE TABLE commend instead of delete,
otherwise you will have to reorganize your table
( EXPOPRT/IMPORT, etc. ).
Anyway - check SELECT statement for FULL table access.
Good luck. Michael.
In article <7ns7kt$ugi$1_at_ns.felk.cvut.cz>,
"Břetislav Černík" <xcernikb_at_hwlab.felk.cvut.cz> 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
>
>
Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.
Received on Fri Jul 30 1999 - 13:41:18 CDT