Remove Brief isn’t useful whenever removed values cause underfilled index stops comprising various directory beliefs whereby the latest inserts occur again. Here’s an example of eg a situation:

Type of numerous rows toward desk. Each submit contributes to an index value which is added to the new top end of one’s list.

Inside condition, this new list reduces regarding the erased index viewpoints end up being underfilled but they are not matched together with other directory blocks due to the use of Brief . They are underfilled when the fresh new inserts exists, since the fresh rows do not have index philosophy from the removed assortment. Additionally, it will always be underfilled even although you afterwards explore Erase in the place of Brief , unless of course a number of the deleted list opinions happen to sit for the index blocks contained in this otherwise near the underfilled reduces. To recover unused index room less than these situations, explore Enhance Desk .