[Feature Request]: add PITR and Snapshot for index tables

### Is there an existing issue for the same feature request?

- [x] I have checked the existing issues.

### Is your feature request related to a problem?

```Markdown

```

### Describe the feature you'd like

Add PITR and Snapshot for index tables

### Describe implementation you've considered

_No response_

### Documentation, Adoption, Use Case, Migration Strategy

```Markdown

```

### Additional information

similar to #22126 . Actually, this was a bug in the correct implementation of PITR and snapshot functionality.