I have been given a new machine that has a little over 1 GB of RAM. When running queries on large tables (8 to 10 mil records) with joins, it does not appear to be utilizing all of the RAM.

Any suggestions?