Is it reasonable to have index on DELETED()? - Level Extreme

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

Is it reasonable to have index on DELETED()?

Message

De

22/03/1999 14:37:31

Walter Meester
HoogkarspelPays-Bas

À

22/03/1999 14:11:20

Christof Wollenhaupt
Foxpert
Norderstedt, Allemagne

Information générale

Forum:

Visual FoxPro

Catégorie:

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

Titre:

Re: Is it reasonable to have index on DELETED()?

Divers

Thread ID:

00196021

Message ID:

00200620

Vues:

10

oops, this should read:

This depends on the number of deleted records in both tables. If there are none, VFP has to read the records anyway. If there are substancial amounts of DELETED records, i agree, the performance can be tuned up with an index on deleted()

Click here to load this message in the networking platform