Select a documentation version: <button class="button button-with-icon cloud-select-dropdown__button button-primary" aria-haspopup="true">18.4.0</button>

- [Current (18.4.0)](https://docs.cloud.google.com/alloydb/omni/linux/current/docs/ai/troubleshoot-columnar-engine-indexes.md.txt)
- [18.4.0](https://docs.cloud.google.com/alloydb/omni/linux/18.4.0/docs/ai/troubleshoot-columnar-engine-indexes.md.txt)
- [18.3.0](https://docs.cloud.google.com/alloydb/omni/linux/18.3.0/docs/ai/troubleshoot-columnar-engine-indexes.md.txt)
- [18.1.1](https://docs.cloud.google.com/alloydb/omni/linux/18.1.1/docs/ai/troubleshoot-columnar-engine-indexes.md.txt)
- [18.1.0](https://docs.cloud.google.com/alloydb/omni/linux/18.1.0/docs/ai/troubleshoot-columnar-engine-indexes.md.txt)

<br />

This document describes commands for diagnosing and troubleshooting columnar engine index operations. Vector indexes use the Approximate Nearest Neighbor (ANN) search strategy that enhances performance and requires a balance between query latency and recall. For more information, see [Choose a vector index in AlloyDB AI](https://docs.cloud.google.com/alloydb/omni/linux/current/docs/ai/choose-vector-index).

<br />

## Ensure index integrity

To verify that an index in the columnar engine is consistent and doesn't have any corruption or errors, especially when you experience issues related to index performance or data retrieval, use the following SQL command:

```sql
  SELECT google_columnar_engine_verify(index => 'INDEX_NAME');
```

Replace `INDEX_NAME` with the name of the index.

## What's next

- Learn more about [Columnar engine overview](https://docs.cloud.google.com/alloydb/omni/linux/current/docs/columnar-engine-overview).