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 04:37:47
 
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:
00975957
Vues:
15
This message has been marked as a message which has helped to the initial question of the thread.
Hi Franco,

if you want to use the $ operator, there is no way to optimize your filter. Try with three index tags, one for Department, one for Section, and one for Unit. Then you can use SET FILTER TO Department=cDept and Section=cSect and Unit=cUnit which will be optimized.

>Hi
>
>I am doing a SET KEY on a table and then I need to run a filter on the records :
>
>SET FILTER TO "[" + Department + Section + Unit + "]" $ cDepSecUnit)
>
>where cDepSecUnit is a list of Department+Section+Unit contained in []. Eg: [Dep1Sec1Unit1][Dep2Sec2Unit2]...
>
>For this filter to be optimised, do I need an index on each of Department, Section, and Unit individually, or do I need one index with all three fields?
>
>Any help would be appreciated. Thanks.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform