Maybe everybody does this, but when I am developing and maintaining a system, I have an indexing program that creates every index I use in the entire system. This serves as 1)allows the user to recreate the indexes even if they are missing entirely 2) serves as a refference of all the tables & their associated indexes when I need to work on the system at a later time.
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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
REINDEXING YOUR TABLES TIP.
- Thread starter martinr
- Start date
- Status
Well, I suggest that you look into Stonefield database toolkit. Stonefield allows you to reindex, repair corrupt tables and update your databases without writing a program to do these functions. It allows you to go straight from database design to production without changing the code every time. Stonefield is a Canada based Software company.<br>
<br>
<A HREF=" TARGET="_new">
<br>
<A HREF=" TARGET="_new">
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question