Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Thank you Cetin
>>Hi every body
>>
>>Whether is there any difference in the speed of data access between the following two methods in relational tables?
>>
>>1) Setting relation on a common numeric field
>>2) Setting relation on a compound of two character fields
>>
>>I am using VFP 6
>>
>>Thank you very much,
>>Ali
>
>In practice almost no. In theory (and might turn out to be practice in huge tables) as the size of key increases, access to index node would be slower. Think like this :
>You have a series of cars and vagons. The key position is 3rd. It'd still be faster to move to 3rd car than to 3rd vagon.
>PS: Honestly AFAIK index structure is not as simple as this sample just for a rough idea.
>Check bintoc(). It's recommended to produce smaller index key sizes when applicable.
>Cetin
Précédent
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