Re: Defragmenting table

Florent,

Is this table significantly *wider* than the others (i.e. does it have a lot of columns, or some very large columns.

We have found that a count(*) pulls the dictionary cache for that table (I think - it was a while ago and may have been some other part of the SGA). So one possible explanation is that a component of the SGA is sized too small.

Len

>Hi there,
>I hope that someone could help me with a little problem.
>I often have to do a query on a table, +/-30000 rows, but for some
>reason the system takes between 10 to 40 secs to return from the select
>count(*), statement, (other tables are 5 times the size and 3 times
>faster).
>There are 2 indexes and 2 primary keys. The size of the table would
>indicate that it should be very quick.
>For the purpose of the application I have to do a select count(*) often
>as the exact number of rows varies from time to time, does any one know
>a better way of doing it or a SQL statement that would defrag the table.
>Any help would be great, (and would make me look great at work).
>Thanks for all the help you can give.
>Florent.
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
  Received on Sun Sep 24 2000 - 14:21:41 CDT