Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Is it reasonable to have index on DELETED()?
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00196021
Message ID:
00200286
Vues:
13
>What do you base that on? I've seen HUGE improvements in query performance achieved by adding a tag on DELETED().

Hi Josh, PMFJI, but I tested the same way Walter did with NOFILTER on. The Deleted index provided no benefit at all, possibly even slowing the query down a bit (though it was very close in my limited test). I have to use NOFILTER, else we get some major problems with creating writeable cursors with USE AGAIN, and occasionally without NOFILTER some very peculiar result sets show up in grids...I've removed all my Deleted indexes in the past week, and my SQL into cursors are running at least as fast as they were, with less CDX overhead...
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform