Too slow to delete millions of record in bucket

SQL++
1

Hi,

I have 1 bucket contains 200mio records.
I need to delete around 30mio records using filter and index but it’s too slow (only around hundreds ops)

Is there any way to faster the process?

Thanks

2

Mutations runs slow.
Best way delete 30M is create covered query (If needed divide and concur filters) and select document key
Then use SDK to set expiration 1sec. Let the documents expire when background expiration algorithm kicks in. or delete use SDK multiple threads reactively