Mike Yearwood
Toronto, Ontario, Canada
General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Or you could have said to simply remove the REINDEX and otherwise leave it alone. I *think* that was the crux of the original question.
I agree, of course, that the PACK would have substantially improved speed by doing a DELETE TAG ALL first. And in a tightly constrained HD-space situation that might be the way one would have to do it.
Cheers
>True enough. I really should have said, you could use delete tag all, pack, do your own indexing routine, or save yourself major grief and buy SDT!
>
>>>So, the best approach to packing would be to delete tag all, pack, do your indexing routine.
>>
>>If you can live with DELETE TAG ALL side effects (e.g. losing information like permanent relations).
Previous
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