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

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

Is it reasonable to have index on DELETED()?

Message

From

22/03/1999 14:37:31

Walter Meester
HoogkarspelNetherlands

To

22/03/1999 14:11:20

Christof Wollenhaupt
Foxpert
Norderstedt, Germany

General information

Forum:

Visual FoxPro

Category:

Databases,Tables, Views, Indexing and SQL syntax

Title:

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

Miscellaneous

Thread ID:

00196021

Message ID:

00200620

Views:

17

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