>By creating our own indices, we were able to get it down to 14 seconds. Now to get permission to have our own indices in the cdx...
>
>Do you know if there is an index on a field named lastname that is using something like alltrim(lastname)... etc and is created in the cdx BEFORE a plain simple index on lastname tag lastname is created, when you do a select statement (from dotnet via oledb) will vfp automatically use the first (bad) tag or will it use the one most optimizable?

It should use the most optimizable index based off the index expression and ignore the tagname.