delete terribly slow : InfluxDB v2.x

__Steps to reproduce:__

1. Ready for some large dataset(table reference↑)
2. Try to execute ```delete from myBucket.autogen.measurement_A where time <= '2022-11-02 23:13:00'``` at ```influx v1 shell(InfluxQL Shell 2.5.0)```
3. Restore data
4. Try to execute ```./influx delete --bucket myBucket/autogen --start 1970-01-01T00:00:00Z --stop 2022-11-02T23:13:00Z --predicate '_measurement="measurement_A"'``` at ```influx CLI 2.5.0```

__Environment info:__
16C32G
Docker / Ubuntu 22.04 / binary execute influxdb OSS v2.5.1

__similar existing bug report:__
https://github.com/influxdata/influxdb/issues/9636 This issue persists in version 2.x as well.

Is there a faster way to delete it?

Start by reproducing the large-dataset deletion with the InfluxQL Shell and the influx CLI commands shown in the issue, using the stated Docker/Ubuntu environment. Compare their timings and investigate the existing issue 9636; done means identifying a supported faster deletion path or confirming the performance limitation with measurements.

Written by the indexing model from the issue text.