What is the best index expression? - Level Extreme

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

What is the best index expression?

Message

De

18/04/2005 13:43:03

Sylvain Larin
Montréal, Québec, Canada

À

18/04/2005 13:35:52

Naomi Nosonovsky
Wisconsin, États-Unis

Information générale

Forum:

Visual FoxPro

Catégorie:

Base de données, Tables, Vues, Index et syntaxe SQL

Titre:

Re: What is the best index expression?

Versions des environnements

Visual FoxPro:

VFP 8 SP1

OS:

Windows XP SP2

Divers

Thread ID:

01005870

Message ID:

01005877

Vues:

14

INDEX ON EMPTY (MyField) TAG E_MyField
SET FILTER TO NOT EMPTY (MyField)

HTH

>If I want to filter all non-empty values for character (100) field, what would be the best expression for the index (if I need the index)?

Click here to load this message in the networking platform