Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Binary index based on field value
Message
De
21/01/2007 20:10:51
Neil Mc Donald
Cencom Systems P/L
The Sun, Australie
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Binary index based on field value
Versions des environnements
Visual FoxPro:
VFP 9 SP1
Divers
Thread ID:
01187555
Message ID:
01187555
Vues:
68
Hi,
With binary indexes are you able to create a logical binary index based on the value of a numeric field i.e. IIF(osbalance=0,.F.,.T.) and have rushmore optimize it within a select.
i.e. Select * from invoice where osbalance=.T.

It would save a lot of space in the index and should be faster as well.
Regards N Mc Donald
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform