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

# Query Ocient

## Docs

- [Query Ocient](https://ocient.ferndocs.com/guides/query-ocient/query-ocient.md): Master querying techniques in Ocient’s data warehouse, including tips for optimizing performance and handling complex data queries.
- [Functions Overview](https://ocient.ferndocs.com/guides/query-ocient/functions-overview.md): Explore Ocient function library for data analysis, manipulation, and transformations, empowering complex querying and calculations.
- [General SQL Syntax](https://ocient.ferndocs.com/guides/query-ocient/general-sql-syntax.md): Explore Ocient SQL syntax rules, enabling users to write clear, efficient queries for data retrieval and manipulation at scale.
- [Ocient HTTP Query API](https://ocient.ferndocs.com/guides/query-ocient/ocient-http-query-api.md): The Ocient Hyperscale Data Warehouse™ has the HTTP Query API that enables you to execute SQL statements. The API follows OpenAPI Specification (Swagger®) guidelines.
- [Query Performance Tuning](https://ocient.ferndocs.com/guides/query-ocient/query-performance-tuning.md): The Query Performance Tuning page explains how to optimize query execution in Ocient to achieve low latency and high throughput on large, complex workloads.
- [Quick Start Querying](https://ocient.ferndocs.com/guides/query-ocient/quick-start-querying.md): Get started with querying in Ocient data warehouse, covering the basics of SQL commands and efficient data retrieval practices.
- [Understanding Data Types](https://ocient.ferndocs.com/guides/query-ocient/understanding-data-types.md): Explore the data types supported by Ocient to store and manage diverse data, ensuring efficient storage and retrieval.
- [Generate Tables Using sys.dummy](https://ocient.ferndocs.com/guides/query-ocient/general-sql-syntax/generate-tables-using-sys-dummy.md): Understand how to create sample tables in Ocient with sys.dummy, a helpful tool for testing and learning SQL syntax.
- [Identifiers](https://ocient.ferndocs.com/guides/query-ocient/general-sql-syntax/identifiers.md): Learn about Ocient identifier rules for naming tables, columns, and other SQL elements, ensuring consistency and clarity in database design.
- [Join Operations](https://ocient.ferndocs.com/guides/query-ocient/general-sql-syntax/join-operations.md): Learn how Ocient® optimizes SQL JOIN operations for high-performance queries without manual tuning. Explore join strategies, hash versus product joins, memory considerations, and best practices for efficient query execution.
- [SQL Syntax Conventions](https://ocient.ferndocs.com/guides/query-ocient/general-sql-syntax/sql-syntax-conventions.md): Understand Ocient SQL syntax conventions, helping you structure queries that are both effective and optimized for large datasets.
- [Array, Tuple, and Matrix Overview](https://ocient.ferndocs.com/guides/query-ocient/understanding-data-types/array-tuple-and-matrix-overview.md): Learn how to work with arrays, tuples, and matrices in Ocient, ideal for handling structured and complex data.