Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Index Error 1884
Message
De
05/04/2016 10:21:57
 
 
À
05/04/2016 09:44:19
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows 8.1
Network:
SAMBA Server
Database:
Visual FoxPro
Application:
Desktop
Divers
Thread ID:
01634277
Message ID:
01634321
Vues:
31
>>INDEX... for disables Rushmore optimization
>
>I don't think so, Bill
>
>Help reads
>
>When Visual FoxPro can determine that a query should not return deleted or undeleted records, and if no unfiltered index is present, it uses INDEX ON <expression> ... FOR DELETED() or INDEX ON <expression> FOR NOT(DELETED()). 
>
>For example, the following queries are now optimized:
>
IIRC the deleted() is a special case trumping the general rules of no rushmore with indeces with for or not.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform