Chris,

What are the expressions in the WHERE clauses of your queries? If you had something like

WHERE MyTable.Customer = MyCustomer AND ;
MyTable.OrderDate BETWEEN DStartDate AND dEndDate AND ;
MyTable.OrderItem = MyItem ...

you would want indexes on Customer, OrderDate, and OrderItem.



>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