---
title: Performance optimization | Tiger Data Docs
description: Diagnose and optimize query performance
---

Optimize your hypertables and queries with indexes, constraints, schema tuning, and TimescaleDB-specific features like chunk skipping and columnstore ordering.

## Schema fundamentals

- [Accelerate queries using indexes](/docs/build/performance-optimization/indexing/index.md)
- [Ensure data integrity with constraints](/docs/build/performance-optimization/ensure-data-integrity-with-constraints/index.md)

## Schema management

- [Alter and update table schemas](/docs/build/performance-optimization/alter-update-table-schema/index.md)
- [Handle semi-structured data with JSON](/docs/build/performance-optimization/handle-semi-structured-data-with-json/index.md)

## Hypertable and query optimization

- [Enforce constraints with unique indexes](/docs/build/performance-optimization/hypertables-and-unique-indexes/index.md)
- [Improve query and upsert performance](/docs/build/performance-optimization/secondary-indexes/index.md)
- [Improve hypertable performance](/docs/build/performance-optimization/improve-hypertable-performance/index.md)

## Advanced

- [Improve storage performance using tablespaces](/docs/build/performance-optimization/manage-tablespaces/index.md)
- [Automate tasks with triggers](/docs/build/performance-optimization/automate-tasks-with-triggers/index.md)
- [Query external data sources with FDW](/docs/build/performance-optimization/query-external-data-sources-with-fdw/index.md)