>Hi,
> I am having Customer ID as primary key for my customer table. I found that, it is slow for searching a customer record using either LOCATE FOR or SQL-SELECT. Therefore, I set Customer ID as regular key in table as well. It really optimized the query. The speed of search is just like "light of speed".
>
>Why could it happen?
>
>Thank you
It could be that the regular key is closer to the physical order of the data. You might try to SORT the file on the PK.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer