I am wondering how Oracle [or any other database] manages and maintains B-Tree indexing for columns with dynamically changing data.
Suppose I have a table with the following columns:
Now if I have indexing on (Status) [which does not make much sense :P], I am wondering how Oracle maintains B-Tree structure for index as described in Oracle docs for B-Tree indexing when value in the indexed column keeps changing.
https://docs.oracle.com/cd/E11882_01/server.112/e40540/indexiot.htm#CNCPT721
For eg. initially, the B-Tree index is organised for a given snapshot of of table and value of Status changes for some records. How does Oracle manage these updates and maintains B-Tree structure for the new snapshot of table with updated Status values. Now the sorted sequence of records would change as values of indexed columns has changed.
How would Oracle internally manage and maintain B-Tree structure in such scenario?
Thanks in Advance.