> For clean Markdown of any page, append .md to the page URL.
> For a complete documentation index, see https://ocient.ferndocs.com/guides/database-administration/schema-design/llms.txt.
> For AI client integration (Claude Code, Cursor, etc.), connect to the MCP server at https://ocient.ferndocs.com/_mcp/server.

# Schema Design

## Docs

- [CREATE TABLE SQL Statement Examples](https://ocient.ferndocs.com/guides/database-administration/schema-design/create-table-sql-statement-examples.md): Access examples of SQL CREATE TABLE statements in Ocient, illustrating best practices for table structure and data types.
- [Secondary Indexes](https://ocient.ferndocs.com/guides/database-administration/schema-design/secondary-indexes.md): Explore the benefits of secondary indexes in Ocient, designed to enhance data retrieval speed and efficiency for large datasets.
- [Table Compression Options](https://ocient.ferndocs.com/guides/database-administration/schema-design/table-compression-options.md): Learn about table compression options in Ocient, optimizing data storage and reducing costs for large-scale data warehousing.
- [Table Retention Policies](https://ocient.ferndocs.com/guides/database-administration/schema-design/table-retention-policies.md): Ocient table retention policies automate data lifecycle management by removing aged records based on time-key columns, reducing manual maintenance and optimizing database performance.
- [TimeKeys and Clustering Keys](https://ocient.ferndocs.com/guides/database-administration/schema-design/time-keys-and-clustering-keys.md): Discover how to use time keys, clustering keys, and indexes in Ocient to improve data organization and query performance.
- [Global Dictionary Compression](https://ocient.ferndocs.com/guides/database-administration/schema-design/table-compression-options/global-dictionary-compression.md): Understand global dictionary compression in Ocient, a technique to reduce data redundancy and improve query performance.