Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
UDF's second rate citizen in Rushmore ?
Message
De
07/09/2006 10:44:33
 
 
À
07/09/2006 09:52:41
Mike Yearwood
Toronto, Ontario, Canada
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
01151219
Message ID:
01151813
Vues:
41
Hi Mike:

special case of Datamining...
the table is *only* written to before any index is created.

All the indeces are used in more than one query -
and here the index involving the UDF is created always again -
and I need it also in some seek/scan - scenarios, so I have
to create it myself as well.

I will probably create redundant fields, as indeces on those
can easily be reused. That should still leave me with 18 months
until I reach th2 2 Gig barrier again <g>.

regards

thomas
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform