Thursday, October 17, 2024
Tip of the Day: Checking Indexes in Descending Order
Product: R:BASE 11
Build: 11.0.1.41008 or higher
Section: Commands
Keywords: AUTOCHK, Index, Descending, Ascending
Did you know that you can check indexes in descending order?
When using AUTOCHK to check an index, it finds the first leaf and walks all the
leaves forward through the B-tree index structure. The AUTOCHK command has been
enhanced to check the index in descending order by finding the last leaf and
walking backward.
AUTOCHK INDEX IndexName DESC
Checking indexes in descending order is a time-saving strategy for detecting
possible index corruption at the end of a large table.
When indexes are being checked, the process reviews each index (.RX3 file) and
walks through every pointer to the data file (.RX2 file). An error is reported
if:
* The pointer from the index does not point to a valid location in the .RX2
file
* The pointer from the index points to a valid location in the .RX2 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 the .RX1 file
The AUTOCHK command can be used to check the integrity of a database, whether
connected or disconnected from the database.
It is ideal to use AUTOCHK to ensure that a database is intact before using the
PACK or RELOAD commands or before making a backup of the database!
Please visit the From the Edge website for indexing and database maintenance.
The technical documents are below.
* Indexing Explained in R:BASE 11
* Database Maintenance
https://www.razzak.com/fte/
Very Best R:egards,
Razzak.
R:BASE Technologies, Inc.
https://www.rbase.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/1789443550.524694.1729142111837%40email.ionos.com.
