I have a VFP database that is being accessed via a .NET 1.1 app with the VFP OLEDB provider.

The table has two fields that used to to query.

POL_ID - Integer (AutoInc)- Primary Key Index
POL_NUMBER - Char (30) - Regular index


When the Select command's where clause uses the POL_ID it is very fast, when the pol_number is used it is slow. What can I do to make it faster. In VFP it is very fast either way.


SELECT * FROM POLICY WHERE POL_NUMBER = '1111111'