Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Primary Key & Candidate Key Index
Message
De
25/01/2003 11:29:53
Gerry Schmitz
GHS Automation Inc.
Calgary, Alberta, Canada
 
 
À
25/01/2003 03:04:17
Lakhani Anil
Lakhani Software Solutions
Mumbai, Inde
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00745042
Message ID:
00745416
Vues:
28
>Yes, since I wnat to store 13 digit number which can be use by numeric 13 or double. But double stores in 8 bytes, while Number will take 13 bytes. Is it overkill? Is it link with corruption of index?

VFP attempts to do index key compression. Storing keys as doubles MAY not work as well as character or integer if VFP fails to find a pattern in the binaries. You may have a smaller DBF, but may wind up with a bigger CDX. A few tests might be in order.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform