home *** CD-ROM | disk | FTP | other *** search
/ NetNews Usenet Archive 1992 #31 / NN_1992_31.iso / spool / comp / database / informix / 2846 < prev    next >
Encoding:
Internet Message Format  |  1992-12-30  |  1.1 KB
  1. Path: sparky!uunet!gatech!emory!emory!not-for-mail
  2. From: dave.snyder@snide.com (Dave Snyder)
  3. Newsgroups: comp.databases.informix
  4. Subject: Re: Corrupted Index
  5. Date: 30 Dec 1992 22:13:17 -0500
  6. Organization: Mailing List Gateway
  7. Lines: 21
  8. Sender: walt@mathcs.emory.edu
  9. Distribution: world
  10. Message-ID: <1htogdINNs8n@emory.mathcs.emory.edu>
  11. Reply-To: dave.snyder@snide.com (Dave Snyder)
  12. NNTP-Posting-Host: emory.mathcs.emory.edu
  13. X-Informix-List-ID: <list.1746>
  14.  
  15. Quoting Bharat Shah...
  16. } 
  17. } Using tbcheck -cI we found that one of the index was bad.
  18. } 
  19. } My options are to:
  20. } 
  21. }    1. Let tbcheck repair the index
  22. }    2. Drop the index and recreate it
  23. } 
  24. } What are the tradeoffs involved in deciding between the two ?
  25. } 
  26. Isn't that one of the primary things tbcheck is supposed to do?
  27.  
  28. Personally, I wouldn't do step number 2 until I've tried step number 1 first.
  29.  
  30. DAS
  31. -- 
  32. David Snyder @ Snide Computer Services - Folcroft, PA          Current Release
  33.                                                                is db4glgen-3.9
  34. UUCP:  ..!uunet!das13!dave   INTERNET:  dave.snyder@snide.com
  35.  
  36.