Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
What are the best indexes to have for a filter ?
Message
De
11/01/2005 09:55:13
 
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 8 SP1
OS:
Windows XP SP2
Database:
Visual FoxPro
Divers
Thread ID:
00975956
Message ID:
00976022
Vues:
10
Please show me a few different SET FILTER expression that you use today, and which you want to run faster, then it's easier for me do give a good answer.

And by the way, do you need to set filter? What about a cursor selected from your table?

>Hi Tore.
>
>Sorry for the delay in answering.
>
>The problem is that if I do not use $ and filter on Department+Section+Unit, I will end up with a huge filter string. I can't build up the filter for department, section, and unit individually.
>
>If i have the three individual indexes and then do the filter as it was originally (Department+Section+Unit $ cDepSecUnit), it still won't be good ?
>
>
>Thanks
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform