>jim,
>the master table has an index on masterid alone, ie .cdx file. (order masterid).
>the transaction file has indexes on (masterid + date) and a second using (masterid + trans# + anotherfield), both part of cdx. i only use the (masterid +date) on the secondary table.
>thanks
>frank

Frank,

You need an index on the trans table on MasterID alone. Rushmore needs that index to optimize the WHERE clause in your SELECT.