---
title: Query Ocient
slug: FDb4eoc4bISmQtf9nVNhY
description: Master querying techniques in Ocient’s data warehouse, including tips for optimizing performance and handling complex data queries.
docTags: 
createdAt: Thu Jul 21 2022 17:05:13 GMT+0000 (Coordinated Universal Time)
updatedAt: Mon Apr 06 2026 18:33:23 GMT+0000 (Coordinated Universal Time)
---

The Ocient Data Intelligence Platform™ 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](<./Query Ocient/Quick Start Querying.md>)&#x20;
- [Query Performance Tuning](<./Query Ocient/Query Performance Tuning.md>)&#x20;
- [General SQL Syntax](<./Query Ocient/General SQL Syntax.md>)&#x20;
  - [Join Operations](<./Query Ocient/General SQL Syntax/Join Operations.md>)&#x20;
  - [SQL Syntax Conventions](<./Query Ocient/General SQL Syntax/SQL Syntax Conventions.md>)&#x20;
  - [Identifiers](<./Query Ocient/General SQL Syntax/Identifiers.md>)&#x20;
  - [Generate Tables Using sys.dummy](<./Query Ocient/General SQL Syntax/Generate Tables Using sys_dummy.md>)&#x20;
- [Ocient HTTP Query API](<./Query Ocient/Ocient HTTP Query API.md>)&#x20;
- [Understanding Data Types](<./Query Ocient/Understanding Data Types.md>)&#x20;
  - [Array, Tuple, and Matrix Overview](<./Query Ocient/Understanding Data Types/Array_ Tuple_ and Matrix Overview.md>)&#x20;
- [Functions Overview](<./Query Ocient/Functions Overview.md>)&#x20;



