General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Hi Dave.
>If I recreate the indexes, will the relational links between my tables need to be recreated too?
Yes, because persistent relations are based on indexes. So, DELETE TAG not only removes an index from the table, but also any persistent relations in the DBC based on that index.
Stonefield Database Toolkit (SDT) handles this automatically. You just call the Reindex method and it takes care of the rest.
>There won't be any changes to the physical structure of the DBC, tables, or indexes. Thus, I'm assuming that the cdx files will pretty much maintain their integrity for a fair amount of time. Is this a wrong assumption?
Unfortunately, lots of things can cause indexes to become corrupted, such as a user rebooting, a workstation or server crash, flaky network cards, etc.
Doug
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