Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Complex Index expression
Message
De
05/11/2008 15:40:01
Dragan Nedeljkovich (En ligne)
Now officially retired
Zrenjanin, Serbia
 
 
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:
Vista
Network:
Windows 2008 Server
Database:
MS SQL Server
Divers
Thread ID:
01359216
Message ID:
01359963
Vues:
28
>>May I ask WHY you need such an index tag? If you have index tags on the relevant fields, a SQL Select statement is normally instant, and most likely gives you exactly what you really want.
>
>I think INDEXES have no bearance on the ORDER BY clause.

Except on speed - if your SQL uses Order By something you have a tag on, Fox uses that to speed up the ordering - or else it would have to build a temporary index or use some other means of ordering the records. So having a tag helps.

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform