IBM® Informix® 12.10

SQL programming

You can use the IBM® Informix® implementation of the SQL language to develop applications for Informix 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 IBM Informix Server (developerWorks®)
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 IBM Informix (developerWorks)
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 Informix (developerWorks)
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 Informix (developerWorks)
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