I have a table of "Work Orders" containing about 30,000 records. Most of the work orders are 'complete', so I have a logical field indicating True or False on completion. For example, I may have 62 orders in use, and 29938 orders completed.

My selects (over a 10baseT network) are somewhat slow and causing heavy network traffic (around 7 seconds to query the table for uncompleted orders).

There was an article in FoxPro Advisor discussing Rushmore optimization, and I think it indicated that an index on a logical field with such a lopsided distribution would cause a substantial amount of the index to be loaded across the network to the client machine.

Is there a 'proper' way to speed up these queries?

Thanks,
Chris