Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations sizbut on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Help NEW but desparate how to rebuild corrupt index 2
- Thread starter saustin
- Start date
-
1
- #2
TamarGranor
Programmer
Code:
DELETE TAG ALL
INDEX ON <key> TAG <tag>
INDEX ON <next key> TAG <next tag>
...Tamar
-
1
- #3
alvechurchdata
Programmer
Tamar has gone straight to the solution but I'll just fill in the gaps and warn you not to be tempted by the REINDEX command.
All REINDEX does is update a good index. If the index is corrupt then you have to go back to basics and create each tag again in code.
Don't run these commands from the Command Window. Write yourself a little program and save it - you might never need it again to recreate an index but a heavily-used index file will grow in size and these commands will reduce the size again.
Geoff Franklin
All REINDEX does is update a good index. If the index is corrupt then you have to go back to basics and create each tag again in code.
Don't run these commands from the Command Window. Write yourself a little program and save it - you might never need it again to recreate an index but a heavily-used index file will grow in size and these commands will reduce the size again.
Geoff Franklin
- Thread starter
- #4
What was unsaid here was a couple other basic things to do before you try to delete tags if the index names and expressions aren't documented and at hand.
First, is the table using a compound index (.cdx) or standalone indexes (.idx)? Whichever, be sure you know what the tag names and expressions are before you delete the tags or standalone indexes. DISPLAY STATUS with the table and indexes open will show the information you need.
Another alternative to get the index details is to retrieve them from backups, just be sure to do that in a separate folder so current and backup tables aren't mixed together.
First, is the table using a compound index (.cdx) or standalone indexes (.idx)? Whichever, be sure you know what the tag names and expressions are before you delete the tags or standalone indexes. DISPLAY STATUS with the table and indexes open will show the information you need.
Another alternative to get the index details is to retrieve them from backups, just be sure to do that in a separate folder so current and backup tables aren't mixed together.
- Status
