Hello All,

I'm in the process a creating a report writer that will be doing a lot of queries off the master table.

Most of the queries will run off of two fields.

where fld1 = x and fld2 = y

To help speed up the process and take advantage of Rushmore, should I index on each field separately or is a compound index the way to go??

Thanks

Sandy