Walter Meester
HoogkarspelNetherlands
Mike Yearwood
Toronto, Ontario, Canada
General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Hi mike,
>That's really clever. You'd build the indexes on an empty table. You'd still have to keep the code around. The same code could create the relations. So, unless that .PRG gets hosed (but with source safe that would be hard), there's
still no advantage to reindex.
I keep CDX files in a seperate dir. In an event of index corruption I copy the empty cdx over the old one and reindex. Deleted relations are manageble as well in some way (e.g. recalling records in the database) but keeping a copy of the empty CDX files is just comfortable enough for me.
I think its just a matter of taste. I see no real advantage of using one strategy over the other.
Walter,
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