Re: Count(*) is very slow

Hi Andreas,

    The Oracle default database and database parameters will not give you decent performance. The defaults appear to have been selected on the basis of allowing you to use Oracle on a system without very much RAM. (Given the price of RAM these days Oracle should probably revise their default strategy.)

    The first thing to do is to go into the init<sid>.ora file (If I remember correctly it's in the ORANT\DBS directory) and change all of the small/medium/large choices to the large values. Next if you have the space double the data base buffer space.

  regards

Jerry

Andreas Kyritz wrote in message <70fiqs$pce$1_at_news.ipf.net>...
>Hi George,
>
>George Meltser schrieb in Nachricht <70ff74$qol$1_at_as4100c.javanet.com>...
>>I have a table with 3,5 mln rows and after it's analyzed it takes 3
seconds
>
>on which server-system do you get this result ?
>
>>to do
>>a count(*), so please stop blaming dbms.
>
>Sorry, but it really takes 36 seconds (3 seconds CPU-time on the server !!)
>after analyzing the table. There is, except of the operating system, no
>other proccess on the server. On the same machine the results with MS SQL
>Server, Centura, Informix and DB/2 - dbms where never so bad.
>
>The database I've used, was created with default values. Do you know, which
>parameter can tune this query ? Is it better, to work with a clustered
>primary key ?
>
>
>--
>Andreas Kyritz
>AKyritz_at_easy-soft-dresden.de
>
>
Received on Mon Oct 19 1998 - 13:36:03 CDT