SQL programming
You can use the HCL OneDB™ implementation of the SQL language to develop applications for HCL OneDB database servers.
Quick reference cards that
are suitable for printing
Portals that list reference information by
functional area and include links
Tools
External resources
- An insider's guide to star join optimization in HCL OneDB Server () Get an introduction to a star join optimization, which can significantly increase query performance for queries on star schemas and snowflake schemas.
- Take advantage of fragment-level statistics and smarter statistics in HCL OneDB () Learn how to improve efficiency by determining when you really need to run update statistics and how to gather fragment-level statistics for fragmented tables.
- SYSDBOPEN: A flexible way to change session behavior in HCL OneDB () Learn how to use the SYSDBOPEN() and SYSDBCLOSE() procedures to set environments to activate user tracing, handle short-lasting locks on data records, or change the reading behavior of sessions. This article shows how to create a SYSDBOPEN() procedure that can be dynamically changed without re-creating the procedure to avoid downtime if session environments must be adjusted.
- Perform case-insensitive queries in HCL OneDB () Learn how to create a not case-sensitive database and explore considerations for implementing check constraints, running distinct searches, running group-by aggregate queries, implementing distributed queries, and more, in a not case-sensitive database environment.
Main resources