Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Hi Friends !
I created a Binary Index on DELETED() using the VP9 and used the command LOCATE FOR DELETED () to locate the first deleted register. I noticed that same using binary indexes the traffic in the net continues very big. My table has just 16000 registers and 5000 are deleted. I think the selectivity ratio is very bad one or I am making some wrong thing.
Everything what i desire is to use the recycling of registers, in other words, the registers are marked as deleted and when necessary I use the command recall to recover them without the need of using PACK.
Does anybody have some suggestion?
Thanks in advance,
[]´s
Dionísio
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