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

# Query Ocient

> Master querying techniques in Ocient’s data warehouse, including tips for optimizing performance and handling complex data queries.

The Ocient Hyperscale Data Warehouse™ contains one or more SQL relational databases. Ocient® follows the PostgreSQL® dialect closely and most functions operate the same in Ocient as in PostgreSQL.

* [**Quick Start Querying**](/guides/query-ocient/quick-start-querying)
* [**Query Performance Tuning**](/guides/query-ocient/query-performance-tuning)
* [**General SQL Syntax**](/guides/query-ocient/general-sql-syntax)
  * [**Join Operations**](/guides/query-ocient/general-sql-syntax/join-operations)
  * [**SQL Syntax Conventions**](/guides/query-ocient/general-sql-syntax/sql-syntax-conventions)
  * [**Identifiers**](/guides/query-ocient/general-sql-syntax/identifiers)
  * [**Generate Tables Using sys.dummy**](/guides/query-ocient/general-sql-syntax/generate-tables-using-sys-dummy)
* [**Understanding Data Types**](/guides/query-ocient/understanding-data-types)
  * [**Array, Tuple, and Matrix Overview**](/guides/query-ocient/understanding-data-types/array-tuple-and-matrix-overview)
* [**Functions Overview**](/guides/query-ocient/functions-overview)