Hi,

I have a table that has about 200,000 rows. Most of the queries do full table scan since they retreive large portion of this table. On every table scan I get very low (sometimes even 0%) buffer cache hitratio. I set the table with the CACHE parameter to cache the retrieve rows, but it still has low cache hit ratio.

How do i increase teh hit ratio? shoul I increase the buffer cache (for now it is 78 MB) and my total RAM is392 MB..

What should I do?

Thanx!