Editing Informix (section)

==Key products==
As of 2023, the current version of both IBM and HCL Informix is 14.10. The major enhancements made over previous releases were adding built-in index compression, integration of JSON collections with support for [[MongoDB]] JSON drivers into the server, and an enhancement permitting database objects to be partitioned across multiple servers in a cluster or grid (aka [[Shard (database architecture)|sharding]]). Queries can optionally return data from the locally connected server instance or from an entire grid with the same SQL.

Informix version 14.10 introduced support for partial indexing where only a subset of the rows in a table are indexed and for multi-valued key indexes which support indexing the elements within multi-valued data types such as LIST, SET, MULTISET, and BSON array fields.

Heterogeneous clusters are fully supported, and there are several deployment options that are available, including some that provide very high levels of data redundancy and fault tolerance.  This feature is marketed by IBM as Informix Flexible Grid.

IBM Informix is offered in a number of editions, including free developer editions, editions for small and mid-sized business, and editions supporting the complete feature set and designed to be used in support of the largest enterprise applications. There used to be an advanced data warehouse edition, including the Informix Warehouse Accelerator (IWA), but it was deprecated in favor of the Advanced Enterprise Edition (which give entitlement rights to IWA).

Regarding HCL Informix, there is a single commercial version available, which is compatible with the IBM Informix Advanced Enterprise Edition, also having rights to IWA. There is also a trial version available, with no known limits, except for an expiration date.

HCL Informix 14.10 key highlights include:  
* Functional parity with IBM Informix 14.10 for on-premises deployment  
* Replacement of FlexNet license management with a script-based monitoring solution, consistent with other Actian offerings  
* Expanded O/S support with the addition of Linux on Power Little Endian and Solaris Sparc.