Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Is filtered index more compact?
Message
 
 
À
02/01/2002 13:37:47
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:
00599852
Message ID:
00599873
Vues:
21
>Nadya
>
>Why don't you just try it on a small table and find out? Its very easy to build a couple of indexes. FWIW, I suspect a filtered index would be smaller, but I haven't checked.

Yes, I'm going to make this test, but thought, somebody already has an answer.

>>Hi everybody,
>>
>>I wrote a message few minutes ago, but I guess, I forgot to send it. Ok, I repeat. I have field APNed (Char 1) and APN (Char 43). I want to create an index APNed+APN for !inlist(APNed,'C',' '). APNed could be D duplicate, S - suspect, B - bad, E - edited. Most common case is "C" - completed or empty - calculation not yet performed. So, my question is: would filter make this index to be more compact?
>>
>>Thanks in advance.
If it's not broken, fix it until it is.


My Blog
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform