Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Slow table
It's possible that slow table has wrong extents definition - too small
and too much. If you have many extents it can be the problem with
reading data or adding columns.
Rafal Czekala
In article <DNtz3.281$zo5.1227_at_news1.online.no>,
"Ulf Grindstad" <griulf_at_online.no> wrote:
> I'm working with a database with several tables,
> I tried to do Select Count(*) from table, on two different tables. One
> returned the answer in about two seconds, and the other used about a
minute.
> I also added a new column on the both tables, and on the slow one it
took
> about a minute, and on the other one it took appr. two seconds. Both
tables
> has around 50000 rows, and 10 varchar2 columns.
>
> Any ideas on what the problem is?
>
> ulf
>
>
Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.
Received on Thu Sep 02 1999 - 09:06:32 CDT
![]() |
![]() |