>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'
What are SET EXACT settings in OLE DB? And SET ANSI?
If it's not broken, fix it until it is.
My Blog