Product Documentation

Database Administrator's Guide

Previous Topic

Next Topic



Inspects the delete node queue <nodes> deep for previously deleted index nodes before adding already existing deleted nodes to the queue.

Default: 50

In server implementations, an emptied index node is not directly deleted from the b-tree. Instead, an entry is placed in a queue read by the special administrative delete-node-thread. Before writing to the queue, a check is made to see if the node is already on the queue. For systems that generate many empty nodes, it can be more efficient to inspect the queue to a deeper level.