Home
AdministeringIn addition to administering the database server, you can tune performance, replicate data, and archive data.
System administrationThese topics contain concepts, procedures, and reference information for database and database server administrators to use for managing and tuning HCL OneDB™ database servers.
Performance GuideThe HCL OneDB™ Performance Guide describes how to configure and operate your HCL OneDB™ database server to improve overall system throughput and to improve the performance of SQL queries.
Optimizer directivesOptimizer directives are comments that tell the query optimizer how to execute a query. You can use optimizer directives to improve query performance.
Types of optimizer directives that are supported in SQL statementsDirectives that are in SQL statements are embedded in queries. These directives include access-method directives, join-order directives, join-plan directives, and optimization-goal directives.
Join-order directives The join-order directive ORDERED tells the optimizer to join tables in the order that the SELECT statement lists them.

Join-order directives

The join-order directive ORDERED tells the optimizer to join tables in the order that the SELECT statement lists them.