Nice cool enhancement! Dan Goldberg
-----Original Message----- From: [email protected] <[email protected]> On Behalf Of A. Razzak Memon Sent: Tuesday, March 17, 2020 6:49 AM To: [email protected] Subject: [RBASE-L] - Tip of the Day: Check Indexes with Enhanced AUTOCHK Command Tuesday, March 17, 2020 Tip of the Day: Check Indexes with Enhanced AUTOCHK Command Product.......: R:BASE X.5 and R:BASE X.5 Enterprise (Version 10.5) Build.........: 10.5.2.20312 or higher Sections......: Commands Keywords......: AUTOCHK, Index, Check, Integrity Did you know database indexes may now be checked with the AUTOCHK command? The AUTOCHK command was enhanced to check all database indexes, or to check a specific index by name. The database must be connected in order to check indexes. AUTOCHK INDEX Specifies to have all the indexes checked. AUTOCHK INDEX indexname Specifies an index to check, which is displayed with the LIST INDEX command. The process reviews each index (file 3) and walks through every pointer to the data file (file 2). An error is reported if: . The pointer from the index does not point to a valid location in the 2 file . The pointer from the index points to a valid location in the 2 file, but the row that lives there has been deleted . The row count from walking the entire index does not match the row count for the table as stored in file 1 Four additional error messages were added for routines to capture and act accordingly. 1609 - Index rows counted: <value1>, expected count: <value2> 1610 - The index points to an invalid row location 1611 - The index points to a row that has been deleted 1612 - The index cannot be examined Very Best R:egards, Razzak. https://www.rbase.com http://www.facebook.com/rbase/ -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/202003171349.02HDn2pc006174%40atl4mhob22.registeredsite.com. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/2E4830CEC16615458329D3D83342F8D001430CAAA9%40exchange11.
