If a query is performing full table scans on some large tables, then you want those tables to be held in the buffer cache so they arn't read physically from disk. However, what's even better is for the table not to be scanned in the first place.
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho