Hi Peter,

my index expressions matches exactly, but I may have had some sort of table corruptions, because after a coplete rebuild of the table and index file, everything is fine. Life is a mystery... :-)

>Is the index expression exacly as you use it in the query. I almost always index on UPPER(cfield) and when I forget to select * from xx where UPPER(cfield)="ABC" and instead use select * from xx where cfield="ABC" it is not optimized anymore.
>Peter
>
>
>>Sergey,
>>
>>I have tried all the four different options, Machine, general, nordan and swefin, all with the same result.
>>
>>By the way, simple LOCATE FOR searches give the same results, but I guess that is logiocal.
>>
>>>Tore,
>>>
>>>What's collate for the indexes?
>>>
>>>>
>>>>I have read more or less all threads regarding VFP9 the last year, but now I face a problem which I can not remember having heard about.
>>>>
>>>>I try a standard SQL select statement, SELECT * FROM myTable WHERE myField=myValue. MyTable has about 700,000 records and is located on a WIN2K server and is shared by many users, all running VFP8. MyTable has many index tags, also on myField. When I run the query on VFP8, the query is fully optimized and is instant. Running VFP9 on the same table, SYS(3054,11) shows no optimizing and takes 7 seconds. Can anyone tell me what I can do to get my speed back into VFP9?
>>>>
>>>>Update:
>>>>I copied the table to another filename on the same server, and removed all the other index tags, and the result was the same, slow on VFP9, instant on VFP8. MyField is C(17), I have tried all the different collate sequences with the same result. But when I copied the table to C:, the query was instant on both VFP8 and VFP9. Now I am even more confused!
>>>>
>>>>Even one more update: Another field in the same table is integer, and has an index tag, and a query in that field is always instant.