John,

Simply a SWAG. . .

Might you have defined the original key with a collating sequence of other than "machine" while the new one you created was with (default) "machine".

I have yet to experience the pleasure of working with alternate collating sequences but I have heard of problems like this with them.

Good luck,

JimN

>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