take advantage of r tree indexing user defined data types and user defined routines are typically defined to support a specific range tree index for a specific database topology a range tree index includes hierarchical nested multi dimensional range levels based on the user defined data types and the user defined routines preferably the r tree index is dynamic with the user defined routines re classifying database contents into updated hierarchical nested multi dimensional range levels responsive to addition modification or deletion of database content by a user the software used to generate and store the user defined routines generally involves operations other than database transactions as a result the operations generating and storing the user defined routines do not create corresponding transaction log entries and so the log based high availability data replicator does not transfer the user defined routines that define a specific r tree index to the secondary side 30 for example in the informix dynamic server environment the user defined routines defining the r tree index are stored on the primary side 10 as a definitional data set such as an r tree capsule 50 residing in the shared memory 16 the r tree index includes multi dimensional range levels such as one or more root levels branch levels and leaf levels indexing information is.