Mike Yearwood
Toronto, Ontario, Canada
Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
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.
>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.
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement