Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
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
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement