General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only