From The Edge: Finding and Fixing Broken Pointers/Indexes
---
For those of you who have downloaded the technical article on
"Finding and Fixing Broken Pointers/Indexes", please note the
correction of example mentioned on page 5. The example
should read as:
SELECT (COUNT(SSN)) INTO v1 INDIC Iv1 FROM Applicant
SELECT (COUNT(SSN)) INTO v2 INDIC Iv2 FROM Applicant +
WHERE RowID IS NULL OR RowID EXISTS
IF v1 = .v2 THEN
PAUSE 1 USING 'INDEX Looks Good!'
ELSE
PAUSE 1 USING 'INDEX Should be Rebuilt!'
ENDIF
RETURN
You may download the updated PDF version of this document
using the following URL:
http://www.razzak.com/fte
(Powered by R:Tango)
My sincere thanks to all who have sent me positive comments,
especially James Bentley for his reviewing skills.
Enjoy!
Very Best Regards,
Razzak.
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: INTRO rbase-l
================================================
TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: UNSUBSCRIBE rbase-l
================================================
TO SEARCH ARCHIVES:
http://www.mail-archive.com/rbase-l%40sonetmail.com/
