You should use a non-standard remove operation when you want to delete a database record or records, based on a key that you specify. If the key you specify is not unique, multiple database records are deleted.
As with any operation where you specify the key yourself, there is no guarantee that the database will be able to access the target records efficiently - it is up to the designer to ensure that appropriate indices are defined to ensure this.