> Oh. You didn't say thta. :-)
Well, I wrote
" Doing a simple "SELECT SUM(MYFIELD) FROM MYTABLE" I noticed "
but don't worry ;)
> How much RAM does your machine have? If it's nearly all cached,
> you'll be CPU bound rather than disk bound.
I'm using Solaris 8.
The SUM() works as expected now (disks works a lot), but accessing by key
is very cpu-intense and still 0% work on disk.
To sum up: table scans are very disk-intense (which make sense), accessing
key leaves disk on idle (I see that it should not work as with a table scan,
but at least a little!)