Data Query Language (DQL)
Data Query Language (DQL) consists of commands used to retrieve data from the database. These operations are strictly read-only and do not modify the underlying data or the database schema.
In almost all relational databases, including Oxibase, the primary and most powerful DQL command is SELECT.
Core Commands
SELECT: The foundational command for querying data. It supports filtering (WHERE), grouping (GROUP BY), sorting (ORDER BY), joins, subqueries, and advanced analytical features like Common Table Expressions (CTEs) and Window Functions.
Query Analysis
Oxibase provides built-in tools to help you understand how your DQL queries are being executed behind the scenes. These are critical for optimizing performance.
EXPLAIN: Shows the planned execution strategy for a query without actually running it.EXPLAIN ANALYZE: Executes the query and returns the plan alongside actual runtime statistics (time taken, rows processed).ANALYZE: Collects statistics about the contents of tables to help the query optimizer make better routing decisions.