>>should I index on each field separately or is a compound index the way to go??

A bit more on the theory here....

For Rushmore to take effect, you must match the expressions EXACTLY. So, if you have a compound index such as fld1+fld2, your WHERE clause will need to look like this:

WHERE fld1+fld2 = x