Revisit all indexes to account for DELETE_PARTITION

Not all indexes are strictly consistent after DELETE_PARTITION. Files is consistent and we made partition stats consistent in HUDI-8345. However, column_stats is only eventually consistent. Basically, the stats for replaced filegroups get deleted when those file groups are cleaned. This is ok because we don't use column_stats in partition pruning. But, we should consider making this check general and make other index types also consider the {{DELETE_PARTITION}} write operation in a distinct way? 
https://github.com/apache/hudi/pull/12953#discussion_r1990324655

## JIRA info

- Link: https://issues.apache.org/jira/browse/HUDI-9171
- Type: Sub-task
- Parent: https://issues.apache.org/jira/browse/HUDI-9096
- Fix version(s):
- 1.1.0