[Feature Request]: Support compression and real time building for Secondary index

### 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?

_No response_

### Describe the feature you'd like

Subtask #476 Both columnar value as well as row_ids are required to be compressed.
Subtask #477 The secondary index should be able to be built together with data ingestion.

### Describe implementation you've considered

_No response_

### Documentation, adoption, use case

_No response_

### Additional information

_No response_

Start by tracing the secondary-index implementation and the data-ingestion path related to this issue. Review subtasks #476 and #477, then define completion as compression for both columnar values and row_ids, plus secondary-index construction during ingestion.

Written by the indexing model from the issue text.